Interested to Buy Any Domain ? << Click Here >> for more details...
without dynamic lookup transformation how to insert new
rows and update existing rows?
- 7 Answers
- 16584 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 |
What does reusable transformation mean?
How you can differentiate between connected lookup and unconnected lookup?
In any project how many mappings they will use(minimum)?
What is the meaning of decode in informatica?
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
What is xml source qualifier transformation in informatica?
what is size of u r database?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
Under which circumstances, informatica server creates reject files?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
what is parallel querying and what r hints.
Where are the source flat files kept before running the session?
Teradata 
