In update strategy target table or flat file which gives
more performance ? why?
Answer Posted / abhinav
I guess the question was wrong as you cannot update a flat file as target.
In a Flat file data can only be inserted not updated.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
waht type of interface is used for testing the data in informatica
What is joiner transformation?
Write the unconnected lookup syntax?
What are the differences between a connected lookup and unconnected lookup?
What is standalone command task?
have u done any performance tuning? how u ll do?
What are the limitations of joiner transformation?
Define joiner transformation?
Define mapplet?
What does refresh system mean, and what are its distinctive choice?
Slowly changing dimensions, types and where will you use them
What is an Integration service in Informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?