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
- 4328 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is difference between a gateway node and worker node?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
During the running session, output files are created by informatica server. Enlist few of them.
Explain lookup transformation source types in informatica
Separate from an archive server and a powerhouse?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the commit type if you have a transaction control transformation in the mapping?
which one is better performance wise joiner or look up
How to join three sources using joiner?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the mapping parameters and mapping variables?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Clarify the utilization of aggregator cache record?
What is a joiner transformation?
How many dimensions are there in informatica?
