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
what are factless facts? And in which scenario will you use such kinds of fact tables.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
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?
Differentiate between a database and data warehouse?
What is workflow manager?
How many ways are there to create ports?
Explain sessions?
In warehouses how many schemas are there?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Describe data concatenation?
How do you load only null records into target?
What is exclusive and normal mode for repository services?
What is the scenario which compels informatica server to reject files?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you load first and last records into target table?