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 to Create a folder using pmrep command?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
What is A complex mapping?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
What are the associated ports in look up T/R.
What does role playing dimension mean?
Write the different tools in the workflow manager?
how will you get 21 to 30 record from 50 records?
What is meta data and system catalog?