without dynamic lookup transformation how to insert new
rows and update existing rows?
- 7 Answers
- 14819 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 |
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
What are the components of the workflow manager?
what is flat file override?
What is difference between a connected look up and unconnected look up?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Could any one to tell Fact table Partitioning?
Teradata 
