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

Two different admin users created for repository are ______ and_______

1 Answers  

how can u approach u r client

2 Answers   CTS,

wf dont have integration severances how you can run?

0 Answers   TCS,

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

What is decode in informatica?

0 Answers  

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

How will you combine 3 different sources with a single source?

3 Answers  

What is galaxy shema

2 Answers   CGI,