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

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

Can you copy the batches?

3 Answers  

What are events in workflow manager?

1 Answers   Accenture, IBM,

How might you approve all mappings in the archive all the while?

0 Answers  

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

Briefly define reusable transformation?

0 Answers  

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

What are the modules in Power Center

0 Answers  

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,