Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 6587

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 16020

whatis the default data driven operation in informatica

2 7046

How to generate a single mapping for both the historical and incremental load.

CSC, TATA,

2 8595

How to eliminate 1st and last rows from the source and load the inbetween rows.

Syntel,

5 26445

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 5348

What are the uses of a Parameter file?

CSC,

3 13856

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 6532

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 7358

List the transformation in informatica.

TCS,

1 12385

where does the default group roew in a router is stored what is the default size of memory in router

1 5171

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 6612

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

Deloitte, TCS,

3 17919

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

Deloitte,

3 26464

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18450

Post New Informatica Questions

Un-Answered Questions { Informatica }

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1310

What is meant by query override?

1118

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1691

How to extract sap data using informatica?

1096

scenario where i can use only concurrent execution of workflow.

3266

What is a grid in Informatica?

1119

hi real timers . iam waiting for ur reply regarding ETL TESTING

2318

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2253

What is data movement mode in Informatica and difference between them?

1187

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2200

How to call shell scripts from informatica?

1044

Explain joiner transformation in informatica

1174

how to load dimension table and fact table. plz tell me the steps.

2146

How to Create a folder using pmrep command?

1224

What is meant by active and passive transformation?

1194

For More Un-Answered { Informatica } Questions Click Here