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
- 16844 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 |
Can we write to_date(three arguments) ? Will it work ? Advance thanks
What is metadata reporter?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
What are active transformations? Name them.
If u r using dynamic cache lookup port will be thier in thet which option u will select
Design a mapping to load the cumulative sum of salaries of employees into target table?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
what is inline view?
What is data transformation manager process?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
Teradata 
