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 |
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
in which situations do u go for starflake schema ?
How can yoU improve session performance in aggregator transformation?
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
What is staging area?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Separate from an archive server and a powerhouse?
How will the document be delivered to me?
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
What are the components of Informatica? And what is the purpose of each?
What is Code Page Compatibility?