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
- 14806 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / himanshu
1. Lookup Transformation (Dynamic lookup enabled)
Use NewLookUpRow Attribute to determine if it is a
new(1),updated(2) or no change(0) record.
2. Update Strategy
Use condition on NewLookkUpRow value to Insert or Update
the record in the target or Reject it.
IFF(NewlookUpRow = 1, DD_Insert, IFF(NewlookUpRow =
2,DD_Update, DD_Reject))
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is workflow? What are the components of the workflow manager?
Could you explain what is enterprise data warehouse?
Where are the source flat files kept before running the session?
What is the format of informatica objects in a repository?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the designer tools for creating transformations?
How can we use batches?
What is the fact table?
How to differentiate between the active and passive transformations?
Explain transaction control transformation in informatica
Explain what transformation and how many are there in informatica?
Mention a few design and development best practices for informatica?
whats the logic to load the lower level of granularity of data to fact table.
How to load the data from a flat file into the target where the source flat file name changes daily?
Different qualification between a related rotate toward the sky and isolates look upward?
