in my lookup table i want to catch the recently updated records from the sourc

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?

Question Posted / ameen

2 Answers
7029 Views
Thomson Reuters, I also Faced
E-Mail Answers

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

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers TCS,

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers

On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers

how to call lookup qualifer in unconnected look;up

1 Answers BirlaSoft,

In a sequential batch can you run the session if previous session fails?

4 Answers

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers HP,

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers Sonata,

Reusable transformation and shortcut differences

0 Answers

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?