How we can use union transformation?
No Answer is Posted For this Question
Be the First to Post Answer
What are the types of lookup transformation?
Can we override a native sql query within informatica?
how to call lookup qualifer in unconnected look;up
How to load the data from people soft hrm to people soft erm using informatica?
How to open an older version of an object in the workspace?
what happens when a batch fails?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
what is curr val use for in sequence generator?
how can we use sorter transformation in joins?
How to delete duplicate record in Informatica?
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
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000