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?

1063

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.

963

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

1241

How do you remove duplicate records in informatica?

1 1387

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

1873

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.

1280

Explain in detail scd type 2 through mapping.

1042

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

1261

Explain the different kinds of facts.

982

How do you load only null records into target?

1216

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

1077

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

1015

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

1147

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is Data Caches size?

1091

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4110

What are the differences between source qualifier and joiner transformation?

1063

what is index?how it can work in informatica

2041

What are the components of Informatica? And what is the purpose of each?

1055

Explain the informatica workflow?

1074

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1946

How to load the data from people soft hrm to people soft erm using informatica?

1020

 Informatica Checkpoints

3332

What is data transformation manager process?

1159

What is a stored procedure transformation?

1056

What is a surrogate key?

1084

Different qualification between a related rotate toward the sky and isolates look upward?

989

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7392

What are the different versions of informatica?

1275

For More Un-Answered { Informatica } Questions Click Here