what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
Answers were Sorted based on User's Feedback
Answer / vikas
Update Strategy Works on Tables and not on files. In session, Treat source rows should be data driven.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abhinaw prakash
For update strategy t/r we should have Constraints defined
on the table.
Else we'll have to use Update override property in session
properties.
Delete in session property we use for deleting a record
based on condition were as truncate is for removing the
previous record from the table before inserting new set of
data.
Is This Answer Correct ? | 1 Yes | 2 No |
how can u tune u r informatica mapppings
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
What is data transformation manager process?
How do you change a non-reusable transformation to reusable transformation?
HOW TO GET THE LATEST DATA IN SCD ?
Hi experts, can anyone tell how much we use plsql in real time
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
In how many ways we can create ports?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
How can we handle two sessions in informatica?