suppose in my source flatfile i have 10000 records in that
some of master table records missed table records missed
then what will u do


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,


What are the different options used to configure the sequential batches?

2 Answers   Wipro,


diffrence between command task and control task

1 Answers   iNautix,


How do you do error handling in Informatica?

1 Answers  


Kimball and Inmon methodologies?

2 Answers  






can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,


What is depict expression change?

0 Answers  


when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  


Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  


In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,


Explain what transformation and how many are there in informatica?

0 Answers  


1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,


Categories