Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000.
but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer


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

Post New Answer

More Informatica Interview Questions

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,


Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,


Why is meant by direct and indirect loading options in sessions?

4 Answers  


Differences between connected and unconnected lookup?

0 Answers  


Hi experts, can anyone tell how much we use plsql in real time

3 Answers  






SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,


What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,


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

0 Answers  


,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,


I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,


what are presession,postsession success and postsession failure commands ?

1 Answers  


Explain lookup transformation in informatica

0 Answers   Informatica,


Categories