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
- 4206 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 |
What is meant by lookup transformation? Explain the types of lookup transformation?
Using Expression transformation how to remove duplicate records from a relational source?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the new features of the server manager in the informatica 5.0?
differences between service based and product based?
Two different admin users created for repository are ______ and_______
What are the challenges you have faced in your project?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what type of transformation is not supported by mapplets?
How to join three sources using joiner?
why we use source qualifier transformation?
Teradata 
