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

Informatica Interview Questions

Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

1062

How do you convert single row from source into three rows into target?

1157

What are the types of schemas we have in data warehouse.

961

Why update strategy and union transformations are active? Explain with examples.

1240

How do you remove duplicate records in informatica?

1 1384

How do you load alternate records into different tables through mapping flow?

1868

How do you load first and last records into target table?

1159

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

Explain in detail scd type 2 through mapping.

1041

How do you load unique records into one target table and duplicate records into a different target table?

1257

Explain the different kinds of facts.

981

How do you load only null records into target?

1216

What is fact table? Explain the different kinds of facts.

1076

How many ways are there to do 'remove duplicate records in informatica'?

1014

How to join three sources using joiner? Explain though mapping flow.

1147

Post New Informatica Questions

Un-Answered Questions { Informatica }

When do you use sql override in a lookup transformation?

1098

is it possible to index the data in cache of lkp transformation ?

2029

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953

What is the status code in stored procedure transformation?

1182

Differences between version 7.x and 8.x.

1893

How to generate sequence numbers using expression transformation?

1089

What are the data movement modes in informatica?

1152

What is informatica metadata and where is it stored?

991

How will the document be delivered to me?

1085

permutations of mapplet

2511

What is repository manager?

987

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

1190

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2198

draw informatica architecture 8.6 ?

3871

lookup transformation with screenshots

4005

For More Un-Answered { Informatica } Questions Click Here