Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11353 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
as per my knowledge
when we use update strategy transformation we will come
across to use this...insert else update...
let us suppose we have two tables a and b. a is the source
table and b is the target table...let us take b which is
target table contains some matched records with 'a' which
is source table. If source table 'a' is modified and
inserted with some records,here we need to update the
records in the target table...therefore by using the insert
else update option in the session properties of target we
can insert new records and update the existing records
correct me if i was wrong
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / naveen
This option we use when we want to maintain the history.
if records are not availabe in target table then it inserts
the records in to target and records are available in
target table then it updates the records.
Regards,
Naveen
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madhavi
if the source table contain multiple records .if the record specified in the associated port to insert into lookup cache. it does not find a record in the lookup cache when it is used find the particular record & change the data in the associated port.
| Is This Answer Correct ? | 0 Yes | 2 No |
hw cn v elimate dublicate values from lookup without overriding sql?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
How many ways are there to do 'remove duplicate records in informatica'?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
what is parallel querying and what r hints.
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
Why update strategy and union transformations are active? Explain with examples.
what is the difference between copy object import objects using repositery manager which one is best
Teradata 
