i have 2 flat files one table contains duplicates another one
no duplicates.... so i need like this i don't want
duplicates...pl's give me ans...
Answer Posted / teja
place sorter transformation after source qualifier of duplicates flatfile and enable property distinct
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Enlist the tasks for which source qualifier transformation is used.
What are the different lookup cache(s)?
What is a passive transformation?
What are the different clients of powercenter?
What is main use of mapplet?
What is powercenter on grid?
What is exclusive and normal mode for repository services?
What is the difference between Active and Passive transformation?
difference between repository database and repository service?
What are the components of the workflow manager?
What is an unconnected transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
list out all the transformations which use cache?
Implementation methodology
Write the advantages of partitioning a session?