Interested to Buy Any Domain ? << Click Here >> for more details...
What is the functionality of update strategy?
- 2 Answers
- 9263 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sivaprasad
Update strategy defines the sources to be flagged for
insert, update,
delete, and reject at the targets.
What are update strategy constants?
DD_INSERT,0 DD_UPDATE,1 DD_DELETE,2
DD_REJECT,3
If DD_UPDATE is defined in update strategy and Treat source
rows as INSERT in Session . What happens?
Hints: If in Session anything other than DATA DRIVEN is
mentions then Update strategy in the mapping is ignored
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chluff12
to decide to insert, update, delete or reject the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is joiner cache?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
Design a mapping to load a target table with the following values from the above source?
What differs when we choose the sorted input for aggregator transformation?
Can we create multiple integration service on single repository?
How to start a workflow using pmcmd command?
how can u avoid duplicate rows in flat file?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to handle changing source file counts in a mapping?
How would you copy the content of one repository to another repository?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
Teradata 
