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

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

How to merge First Name & Last Name?

8 Answers  

What are the data movement modes in informatcia?

1 Answers  

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

Can you copy the batches?

3 Answers  

What is aggregator transformation in informatica?

0 Answers  

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

What is IQD file?

1 Answers  

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,