how to get the only updated records in the target

Answers were Sorted based on User's Feedback



how to get the only updated records in the target..

Answer / chandrasekar

Using unconnected lookup

Is This Answer Correct ?    0 Yes 1 No

how to get the only updated records in the target..

Answer / jvdwhinfo

Using incremental aggregation.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

in performance wise union is past,union all is past

2 Answers  


How informatica process data means how informatica works?

2 Answers   TCS,


Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,


Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  






Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,


What is meta data and system catalog?

2 Answers  


How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,


How to delete duplicate records in a flat file source?

2 Answers  


what is mystery dimension?

1 Answers  


write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,


Categories