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

Informatica Interview Questions

Questions Answers Views Company eMail

Explain the types of lookup transformation?

1045

How we can confirm all mappings in the repository simultaneously?

1 1449

Which is the t/r that builts only single cache memory?

1190

Why filter transformation is an active one?

987

What are the components of the workflow manager?

1136

If informatica has its scheduler why using third party scheduler?

1268

How can you increase the performance in joiner transformation?

1191

What are the restrictions of union transformation?

1041

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1268

How can we update a record in the target table without using update strategy?

1150

What are the advantages of informatica?

1014

Describe the impact of several join conditions and join order in a joiner transformation?

1063

What is persistent lookup cache?

1030

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248

What are the uses of etl tools?

1128

Post New Informatica Questions

Un-Answered Questions { Informatica }

what is INFORMATICA TESTING process

2294

Mention some types of transformation?

1048

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1272

What is the difference between informatica 7.0 and 8.0?

1016

What is primary and backup node?

1128

What is the need of an ETL tool?

1101

Differences between version 7.x and 8.x.

1896

Different sorts of metadata that stores in the storage facility?

1012

What all join we can perform in LOOKUP transformation?

978

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

2094

What is rank index in rank transformation?

1080

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

1013

What is blocking transformation?

1145

Which development components of informatica have the highest usage?

1044

For More Un-Answered { Informatica } Questions Click Here