without dynamic lookup transformation how to insert new
rows and update existing rows?
- 7 Answers
- 15294 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / sarthak
with SCD Type-1...
it uses normal look-up (not the dynamic look-up)
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
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 |
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
What are the out put files that the informatica server creates during the session running?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
in realtime which situations u can use unconnected lookup transformation
What is the fact table?
Write the prerequisite tasks to achieve the session partition?
How can i send first half of the records to one target and Remaining to other target?
How can we create index after completion of load process?
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
Teradata 
