Can we update the data in flat file using update strategy?
Answer Posted / kishore
never use UPDATE STRATEGY for flatfiles
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
4 yrs etl devloper roles and responsibilities?any body give solutions
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How can we delete duplicate rows from flat files?
How to generate sequence numbers using expression transformation?
How do you handle two sessions in Informatica
What is union transformation in informatica?
How to join three sources using joiner? Explain though mapping flow.
What can we do to improve the performance of informatica aggregator transformation?
How an expression transformation differs from aggregator transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the difference between informatics 7x and 8x and what is latest version?
How can we store previous session logs?
How to elaborate tracing level?
What are the various types of transformation?