Answer Posted / manjunath
in update strategy flag 4 means INSERT.
0 Insert
1 Update
2 Delete
3 Reject.
if we give any other value the integration service will
treat any other value as an INSERT.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is data caches/ index caches?
What are the different ways to implement parallel processing in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
What is the difference between informatica 7.0 and 8.0?
What is the use of code page?
What are the different components of powercenter?
In warehouses how many schemas are there?
Explain target update override in informatica
What is the difference between a repository server and a powerhouse?
What do you mean by channel change?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is a grid in Informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
