The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performance of the Informatica Server is related to network connections. Data generally moves across a network at less than 1 MB per second, whereas a local disk moves data five to twenty times faster. Thus network...

srinivas

• Oct 4th, 2011

Your approach to that question and answer is perfect and correct

ankitmohansharma

 Profile Answers by ankitmohansharma Questions by ankitmohansharma

• Jan 13th, 2008

Hey, Thank You so much for the information. That was one of the best answers I have read on this website. Descriptive yet to the point and highly useful in real world. I appreciate your effort.

Answer Question  Select Best Answer

What is bridge table?

surendra

• Oct 11th, 2011

When we need to do many to many relation ship between dimensional table and fact table we can it as Bridge Table , simply we can bridge table sits between fact table and dimensional Table ..

Answer Question  Select Best Answer

Explain how the batch processing works in informatica ? When would it be useful in real-time projects ?

snigdha ojha

• Oct 12th, 2011

When we run multiple sessions in a single workflow sequentially that is called batch processing. This is useful when we create relational database for any company.

Answer Question  Select Best Answer

What is the significance of the file odbc.ini?

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

The main significance of ODBC is it to connect to the desired database and fetch the data.

Sriteja

• Aug 27th, 2011

One of the uses of the ODBC.ini file is to handle SQL Server, Teradata connections from Unix flavoured Informatica Server installations...

There can be more to it.. However, we use odbc.ini in our project to connect SQL Server database from powercenter installed in Linux server..

Answer Question  Select Best Answer

In session level, What is the difference between Informatica 7 and 8

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

The main difference is

1) Architecture difference
2) Java trasformation has been introduced
3)user defined functions
4)dynamic configuration of cache and partitioning.

Answer Question  Select Best Answer

What are the different types of partitons in Informatica?

• Oct 21st, 2011

Informatica partitions are used to improve the performance of power center through parallel data processing. The different types of informatica partitions are database partition, pass-through partitio...

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Oct 25th, 2011

Excel source is possible through File DSN - Target XML also can be done - read the documentation or help for more information

kumar

• Oct 21st, 2011

First we need to save the excel file in csv file and then we have xml transformation in informatica by using that we can convert csv file to xml file

Answer Question  Select Best Answer

How to kill 10 workflows at a a time ?

vizaik

 Profile Answers by vizaik Questions by vizaik

• Oct 25th, 2011

Write 10 pmcmd commands with abortworkflow option in one bat/sh file and execute at once

wanilkumar

 Profile Answers by wanilkumar Questions by wanilkumar

• Oct 7th, 2011

It is not possible to kill multiple workflows at a time. You must Abort/Stop one at a time.

I think starting with the version 8.6 you can run the same workflow multiple times at the same time.

Answer Question  Select Best Answer

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

KOTI

• Oct 31st, 2011

First find out the problem whether it is due to aggregator transformation or not. Run debugging...

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

You can use incremental aggrigation.

Answer Question  Select Best Answer

What are few real time issues or problems while doing Informatica project. As a Informatica ETL developer, what will be the daily tasks or work.

sreenu

• Nov 19th, 2011

Actually it depends on the projects...

Anyway you will see the below issues in general

1. some specific characters are not loading as in the source
2. Data truncation happened on few fields
3. Frequent changes are coming from the user
4. Performance issues when loading huge data

Answer Question  Select Best Answer

please explain working with transactions in joiner transformations. What conditions are set. And any scenarios where it is used.

Sreenu

• Nov 19th, 2011

Please get this information from the Informatica help file( no one can give better than in help)

Let us if you are looking for the answer on any specific requirement

Answer Question  Select Best Answer

While reading flat files can we increase the default size of 1024 bytes of a line?If yes then is there any upper limit for that?

Sreenu

• Nov 19th, 2011

Yes, we can increase the line sequential buffer length in the session properties.

There is no hard limit actually, but when the block size and the DTM buffer size also should be increased to be able to process the records

Answer Question  Select Best Answer

I need to comment the stored procedure in the mapping

sreenu

• Nov 19th, 2011

Pass dummy argument and do not connect the output of the stored procedure to actual fields.. you this as pass through transformation if it is a connected one

if it is unconnected t/f then you can simply ignore the output of the field in the expression

Answer Question  Select Best Answer

Suppose in my mapping 3 pipelines are there from source to target and i want to run the middle pipeline only.

Suhel Shaikh

• Nov 24th, 2011

Example; If we have two pipelines in a single mapping then whichever pipeline you do want to run just add 1=2 in the SQ override as a last statement.And create two sessions for the same mapping and add this statement to the SQ of one source which you don't want to run.It will run the other one.

SEHAJ SHANGARI

• Aug 18th, 2011

In designer.
Select mapping tab
There is a property target load plan
Select the source qualifier and the target which u want to run the first n place it in first position. Followed by other pipelines

Answer Question  Select Best Answer

I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.Please, any one have a solution to this problem(I installed Informatica 7.1 on WINDOWS XP Home Edition, Oracle 10g)Thanks a lot.nagesh

k.praveenkumar

• Dec 6th, 2011

Software could be corrupted or has attacked with Virus,
Re-install and if the problem persist then you change the OS and try Informatica, it may work.

Srikanta

• Nov 11th, 2011

In order to up your IRS, please follow up the guidelines:- 1) Create a database, if u have already DB exist, then u can go with the same. 2) Create two db users, give admin privilege to those users....

Answer Question  Select Best Answer

venkat

• Dec 14th, 2011

In the look up properties whenever you check the dynamic lookup cache is enable, in lookup table new column is added automatically that is newlooup port. If the new lookup port is 0 then there is no change. If it is 1 insert and if it is 2 update.

srikanth

• Nov 18th, 2011

How to get total as new row and sum as 10.000

Code
 

Answer Question  Select Best Answer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Dec 20th, 2011

In Stored Procedure transformation we can also specify when the SP should run.Its Normal,Pre-load of the Source,Post-load of the Source,Pre-load of the Target and Post-load of the Target. Pre-load of...

Anubhav Raikar

• Nov 15th, 2011

If you are asking this in terms of Stored Procedure Transformation, then the SP would be run before the Source fetches any data (in case you select Source PreLoad) .. and in case of Source PostLoad th...

Answer Question  Select Best Answer

What is the difference between index cache and data cache

santosh

• Dec 26th, 2011

Index cache : Integration service stores all conditional values in to the index cache and all output values into the data cache.

Please correct me anything wrong

skaur29

 Profile Answers by skaur29 Questions by skaur29

• Nov 17th, 2011

If we talk with respect to Aggregate Transformation , then Index Cache stores the Group Values and data Cache stores the Actual Data which is Row data.

Answer Question  Select Best Answer

Santosh

• Dec 26th, 2011

In Informatica 4 types of dimensions are available, these are 1) Degenerate dimensions 2) Junk dimesnsions ( a dimension which contains the less numbers of cordinality vales are less number of ind...

suren

• Nov 22nd, 2011

Hi Guys, Please don't answer wrong answers the above mentioned are Schema. , the dimension are discussed bellow. 1.Junk Dimension:Contains miscellaneous data such as flags and indicator 2.Degener...

Answer Question  Select Best Answer

Which functions are used in Union Transformation?

rangarao.dwh

 Profile Answers by rangarao.dwh Questions by rangarao.dwh

• Jan 9th, 2012

Union Transformation works like as Union All in SQl and in this transformation we cant use any external functions like avaliable in expersion editor means which is specially designed for joining the records vertically.

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

i didnt understand the question. First, a union transformation is active transformation which is used to combine data from multiple sources into single target. This union transformation supports union...

Answer Question  Select Best Answer