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

What is operational data source (ODS)?

7 Answers  


In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,


What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,


What does role playing dimension mean?

0 Answers  


Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  






if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,


Explain how to import oracle sequence into informatica?

0 Answers  


What is the difference between stop and abort in informatica

0 Answers   Informatica,


A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  


Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,


Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,


how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,


Categories