How You Pull the records on daily basis into your ETL Server.

Answers were Sorted based on User's Feedback



How You Pull the records on daily basis into your ETL Server...

Answer / bharu_295

using incremental loading

Is This Answer Correct ?    4 Yes 0 No

How You Pull the records on daily basis into your ETL Server...

Answer / munireddy

uning incremental/delta/cdc..

for this we have so many logics some of them are..
using mapping level variable
using control table and ....

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

How do you use reject loader.

0 Answers  


In which scenario did you used pushdown optimization?

1 Answers  


i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,


What is the reusable transformation?

0 Answers  


how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,






How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,


create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,


what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,


What is main use of mapplet?

0 Answers  


Can we override a native sql query within informatica?

0 Answers  


What are the designer tools for creating tranformations?

1 Answers   Informatica,


Categories