How can we eliminate duplicate rows from flatfile,explain?
Answer Posted / veera reddy
By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
Explain joiner transformation in informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to create a non-reusable instance of reusable transformations?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is informatica worklet?
Which files are created during the session rums by informatics server?
Explain the different kinds of facts.
What is incremental aggregation?
What are the prerequisite tasks to achieve the session partition?
How to differentiate between the active and passive transformations?
What do you mean incremental aggregation?
What is dimensional table? Explain the different dimensions.
What is fact table? Explain the different kinds of facts.
How to call shell scripts from informatica?
Can you generate sequence numbers without using the sequence generator transformation?