How You Pull the records on daily basis into your ETL Server.
Answers were Sorted based on User's Feedback
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 |
How do you use reject loader.
In which scenario did you used pushdown optimization?
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
What is the reusable transformation?
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)
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
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
create a mapping to retrieve the employees who are getting salary greater than average salary?
what is normalization? explain 1st NF, 2nd NF, 3rd NF
What is main use of mapplet?
Can we override a native sql query within informatica?
What are the designer tools for creating tranformations?