without dynamic lookup transformation how to insert new rows and update existi

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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

Question Posted / dinesh

7 Answers
14270 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / jhansi

YES,we can insert new rows and updat existing row
By setting Session level properties
1.Session->properties->TreatSourceRowas Update
2.Session->mapping->target properties->select update else
insert

Is This Answer Correct ?

8 Yes

1 No

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

Answer / sujana

@above

then wat is the use of lukup..if v can load in dis way

Is This Answer Correct ?

5 Yes

1 No

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

Answer / vali

you can use source qualifier transformation to do this.
write join condition ...
the rest of the operation will be same

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sarthak

with SCD Type-1...

it uses normal look-up (not the dynamic look-up)

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sujit

by the use of update strategy T/R we can insert new row and
updae a existing row on the time of T/R

Is This Answer Correct ?

1 Yes

1 No

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

Answer / murali raju

Simple you can take one look up transformation give the
condition as empno=empno1(if it is primary key) and take
update strategy transformation just pass condition as
IIF(empno=empno1,dd_update,dd_insert). in this way we can
insert new records and update old records without keepimg
historical data.

Is This Answer Correct ?

0 Yes

0 No

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

Answer / bj

With out lookup and update st. transformation we can still
insert new and update data at session level.
in session at the time giving target table connect bottom u
find insert and update just check that box.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer