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 can you define a transformation? What are different types of transformations in Informatica?
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?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is the Difference between sorter and aggregator?
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
What is meta data and system catalog?
what is work of PUSH DOWN option
What are the different caches used in informatica?
In real time scenario where can we use mapping parameters and variables?
can every transfomation reusable?how?
can a port in expression transf be given the name DISTINCT