1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / lakshmi

Answers were Sorted based on User's Feedback



S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same ..

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

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same ..

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

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same ..

Answer / sushma

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

Is This Answer Correct ?    1 Yes 0 No

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same ..

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

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same ..

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

Post New Answer

More Informatica Interview Questions

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

What are the restrictions of union transformation?

0 Answers  

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,




Explain sessions and how many types of sessions are there?

0 Answers  

Differentiate between a repository server and a powerhouse?

0 Answers  

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

Why touse stored procedure in ETL Application?

2 Answers  

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

What is the capacity of power cube?

1 Answers  

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

2 Answers   HCL, Schneider,

For more Informatica Interview Questions Click Here
Categories