How to identify this row for insert and this row for update in dynamic lookup

How to identify this row for insert and this row for update
in dynamic lookup cache

Question Posted / ravindra.15aug

3 Answers
9608 Views
CSC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to identify this row for insert and this row for update in dynamic lookup cache..

Answer / kish

Hi Based on NEW LOOKUP ROW..informatica server indicates
which one is insert and which one is update.
New lookup row=0...no change
1....Insert
2....update

Is This Answer Correct ?

16 Yes

2 No

How to identify this row for insert and this row for update in dynamic lookup cache..

Answer / krish

0 The PowerCenter Server does not update or insert the row
in the cache.
1 The PowerCenter Server inserts the row into the cache.

2 The PowerCenter Server updates the row in the cache.

Is This Answer Correct ?

6 Yes

3 No

How to identify this row for insert and this row for update in dynamic lookup cache..

Answer / ravindra.15aug

By using data driven

Is This Answer Correct ?

3 Yes

5 No

Post New Answer

More Informatica Interview Questions

How is Data Models Used in Practice?

1 Answers

Differentiate between reusable transformation and mapplet.

0 Answers

What are the Differences between connected and unconnected lookup?

6 Answers TCS,

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers TCS,

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers IBM, Infotech,

What are parallel querys and query hints?

1 Answers

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers TCS,

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers CTS, HCL, Infosys, TCS,

What are batches?

0 Answers

For more Informatica Interview Questions Click Here