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?

933

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

1165

What is xml source qualifier transformation in informatica?

1186

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?

1116

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

985

What do you understand by term role-playing dimension?

1005

What is parallel processing in informatica?

1646

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

908

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

1 1424

WHat all joins are there in Source Qualifier?

1 2467

What all join we can perform in LOOKUP transformation?

930

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

962

Different circumstance which drives informatica server to expel records?

935

Separate from an archive server and a powerhouse?

919

Make a note of the quantity vaults made in informatica?

953

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to join three sources using joiner?

1051

How many input parameters can exist in an unconnected lookup?

1513

What all join we can perform in LOOKUP transformation?

930

What are some examples of informatica etl programs?

906

what is the hint? how to use it to reduce the query processing in program?

7690

How to do unit testing in informatica?

1137

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2262

How are indexes created after completing the load process?

1572

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2013

I have a flat file, want to reverse the contents of the flat file

1078

Slowly changing dimensions, types and where will you use them

1671

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

4088

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2007

What is an active transformation?

1050

What are the features of complex mapping?

1110

For More Un-Answered { Informatica } Questions Click Here