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
- 14562 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / madhava
In this scenario generally using the two transformations
(Joiner&UpdateStrategy Tx) if S1 and S2 are different
sources or Flat files;
Else if both are in same sources as of relational then
join it in SourceQulaifier Tx itself in this case no need
for Joiner tx.
1) Joiner Tx will join the S1 and S2 by using common
fields; here S2 is the Master table.
2)In UpdateStrategy Tx. Condition is like IIF
(s2.empno=s1.empno,1,0)
| Is This Answer Correct ? | 6 Yes | 6 No |
Answer / sachin
The pipeline is as follows
sqr->exp->lkp->exp->upd->tgt
Lookup Transformation (Dynamic cache 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 ? | 0 Yes | 0 No |
What is the difference between bitmap and btree index?
what is $$$$?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
what is the size of u r source(like file or table)?
how many types of dimensions are available in informatica?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
list out all the transformations which use cache?
how to load rows into fact table in data warehouse
what is lookup chache?
How to create a non-reusable instance of reusable transformations?
What is workflow? What are the components of workflow manager?
Explain pushdown optimization $pushdownconfig parameter - informatica
Teradata 
