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?

736

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

883

What is xml source qualifier transformation in informatica?

922

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?

968

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

775

What do you understand by term role-playing dimension?

760

What is parallel processing in informatica?

1267

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

727

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

1 1091

WHat all joins are there in Source Qualifier?

1 2080

What all join we can perform in LOOKUP transformation?

732

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

730

Different circumstance which drives informatica server to expel records?

718

Separate from an archive server and a powerhouse?

661

Make a note of the quantity vaults made in informatica?

742

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the steps involved in the migration from older version to newer version of Informatica Server?

1806

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1734

How identifying bottlenecks in various components of informatica and resolving them?

801

What is the maplet?

791

What is dimensional table? Explain the different dimensions.

871

What is intricate mapping?

786

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2064

What is joiner transformation?

734

What are the informatica performance improvement tips

805

What are the differences between joiner transformation and source qualifier transformation?

849

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1657

How many types of sessions are there in informatica.please explain them?

885

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2484

What is decode in static cache?

779

What is the reusable transformation?

811

For More Un-Answered { Informatica } Questions Click Here