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

Informatica Interview Questions

Questions Answers Views Company eMail

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

976

How does a rank transform differ from aggregator transform functions max and min?

1204

What is xml source qualifier transformation in informatica?

1217

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1169

What differs when we choose the sorted input for aggregator transformation?

1021

What do you understand by term role-playing dimension?

1048

What is parallel processing in informatica?

1712

What is meant by lookup transformation? Explain the types of lookup transformation?

948

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 1480

WHat all joins are there in Source Qualifier?

1 2545

What all join we can perform in LOOKUP transformation?

975

Difference between Target-based loading and constraint-based loading?

998

Different circumstance which drives informatica server to expel records?

983

Separate from an archive server and a powerhouse?

962

Make a note of the quantity vaults made in informatica?

988

Post New Informatica Questions

Un-Answered Questions { Informatica }

how we can load rejected record's at run time?(not through bad files)

2379

What are the databases that informatica can connect to windows?

1049

What is a passive transformation?

1103

Make a note of the quantity vaults made in informatica?

988

What is a grid in Informatica?

1069

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4160

What is update strategy transform?

1101

Explain in detail about scd type 1 through mapping.

1553

Clarify the utilization of aggregator cache record?

1000

How do you handle two sessions in Informatica

1164

Explain the features of connected and unconnected lookup.

935

How can we remove the duplicates from flat file source?

1038

how to load rows into fact table in data warehouse

1188

Can we create two repositories on same database instance in oracle?

1090

where to store informatica rejected data?

1093

For More Un-Answered { Informatica } Questions Click Here