Interested to Buy Any Domain ? << Click Here >> for more details...
what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
- 2 Answers
- 4325 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
To achieve the session partition what r the necessary tasks u have to do?
can you please explain me pre session and post session options?
What is a sequence generator transformation?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
How can you display only hidden files in UNIX
How many numbers of sessions can one group in batches?
4 yrs etl devloper roles and responsibilities?any body give solutions
can u any challenge your project?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
In informatica workflow manager, how many repositories can be created?
Teradata 
