For stage table data processing, suppose in first run we
processed 8 records out of 10 records then in 2nd run we
should consider only not processed records (here total no
of records =2) along with new records which got loaded in
stage table thru real time mapping.
Note : In this example, 8 records are those records for
which we got transaction number after lookup on trn_no_cod
table and 2 records for which lookup returns trn_no as NULL
Answer / abhinav
In the 2nd run if u want only the records which have not
processed then do Lookup on the target and pass the output
to the target.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
what type of problem you faced insales project or insurance project
What are the types of maping in Getting Started Wizard?
what is lookup chache?
What is union transformation in informatica?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
"Change cache" in Informatica ?
What is confirmed fact in dataware housing?
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,
what is curr val use for in sequence generator?
What is souce qualifier transformation it is active or passive