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.

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))

Answer / sushma

I go with Naveen's solution with a small change. I would
replace filter with Router TRFM.

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)

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))

what is hash table in informatica?

1 Answers   Zensar,

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  

What is limitations of truncate and load option

1 Answers   Cap Gemini,

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

What are pre and post-session shell commands?

0 Answers  

How to load a Dimension ? and how to load a fact table?

0 Answers  

What is union transformation?

0 Answers  

What is confirmed dimension and fact?

7 Answers  

How can you recover the session in sequential batches?

1 Answers