in my lookup table i want to catch the recently updated
records from the source to target,how to achieve this and what
is last commit interval point for this?

Answers were Sorted based on User's Feedback



in my lookup table i want to catch the recently updated records from the source to target,how to a..

Answer / davankumar

By using of dynamic cache .

Is This Answer Correct ?    11 Yes 1 No

in my lookup table i want to catch the recently updated records from the source to target,how to a..

Answer / prasanna

BY using dynamic lookup cache it is possible

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

Differentiate between joiner and lookup transformation?

0 Answers  


How can we remove the duplicates from flat file source?

0 Answers  


How do you handle decimal places while importing a flatfile into informatica?

1 Answers  


how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,


what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,






i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,


if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,


Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,


Is there any model difference between ODS and DWH

2 Answers   Zensar,


SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,


how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,


Define update strategy?

0 Answers  


Categories