1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

What is Session and Batches?

0 Answers   Informatica,

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

is it possible to index the data in cache of lkp transformation ?

0 Answers  

In Which scenario did u used Incremental loading?

2 Answers  




How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  

How is Data Models Used in Practice?

1 Answers  

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

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. can any tell me procedure.

2 Answers   TCS,

What is DTM process?

4 Answers  

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

For more Informatica Interview Questions Click Here
Categories