How to eliminate duplicates from flat file..what is the
procedure
Answer Posted / ram
one more answer is ....
use an aggeregator transformation and select all ports
as 'group by'...then u will get distinct records...
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
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
What is a grid in Informatica?
Differentiate between a database and data warehouse?
Could you explain what is enterprise data warehouse?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is the Default Source Option For Update Strategy Transformation?
Explain sql transformation in script mode examples in informatica
Write the advantages of partitioning a session?
What is Session and Batches?
Explain how many types of dimensions are available in informatica?
How to handle decimal places while importing a flatfile into informatica?
What is aggregator transformation in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
How can you increase the performance in joiner transformation?
In warehouses how many schemas are there?