Interested to Buy Any Domain ? << Click Here >> for more details...
S1 is having 1 lakh records and s2 is having 100 records,
s2 should compare s1 if emp no is same data should be
updated if not their it should insert the data.what are the
transformation used?
- 5 Answers
- 14563 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / k naveen kumar
Here we have to use lookup and update strategy and filter
Take s1 as source and take lookup on s2 just u will get the
output.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Difference between Data and Index Caches?
How do you load alternate records into different tables through mapping flow?
What all join we can perform in LOOKUP transformation?
What is a sequence generator transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the differences between source qualifier and joiner transformation?
What are the measure objects?
What is a sorter transformation?
What is the status code in stored procedure transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How might one distinguish in the case of mapping is right or not without associating session?
What is a stored procedure transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What do you mean incremental aggregation?
