What is the functionality of update strategy?
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 |
A session S_MAP1 is in Repository A. While running the session error message has displayed
What is source qualifier?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
how you will maintain version?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
How we will implement Pushdown Optimization and Types in Informatica with better examples
How do you use reject loader.
what is galaxy repository?
What are the mapping paramaters and mapping variables?
What are the tuning techniques you applied during your last project