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 |
can we load the data with out a primary key of a table? what is target plan?
How do you load only null records into target? Explain through mapping flow.
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
hw cn v elimate dublicate values from lookup without overriding sql?
What you know about transaction control transformation?
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
How to eliminate duplicate records in informatica mapping? Explain with an example....
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
can any one explain me about junk dimension