Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

How do you load only null records into target? Explain through mapping flow.

1015

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

285


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the difference between informatics 7x and 8x and what is latest version?

346


When do you use sql override in a lookup transformation?

377


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

360


What is sq transformation?

385


Define pmcmd command?

398






If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

816


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

481


What is a rank transform?

398


Explain informatica architecture - version 8 / 9

477


Slowly changing dimensions, types and where will you use them

1062


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

1308


How can we improve session performance in aggregator transformation?

466


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1471


How many numbers of sessions can one group in batches?

405


What are the new features of informatica 9.x at the developer level?

399