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 6486

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 15821

whatis the default data driven operation in informatica

2 6918

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

CSC, TATA,

2 8482

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

Syntel,

5 26228

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 5270

What are the uses of a Parameter file?

CSC,

3 13684

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 6480

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 7232

List the transformation in informatica.

TCS,

1 12321

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

1 5080

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 6524

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 17800

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

Deloitte,

3 26309

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18310

Post New Informatica Questions

Un-Answered Questions { Informatica }

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2402

What is a snowflake schema?

999

What are the databases that informatica can connect to windows?

1058

What is the cumulative sum and moving sum?

1186

what is degenerated dimension?

4001

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1802

How do you take back up of repository?

1162

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1015

What are the types of presistent cache in look up tr.

2058

What is the need of etl tools?

1122

What is standalone command task?

1319

How do you update the records with or without using update strategy?

1121

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1082

Explain the difference between a data warehouse and a data mart?

1062

What does refresh system mean, and what are its distinctive choice?

1187

For More Un-Answered { Informatica } Questions Click Here