Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15444 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
duplicate records can be eliminated the following ways:
1) by using select distinct option
2) by over riding sql with group by port on the column
which gets duplicate values ( P_key column)
3) by connecting the source to an expression transformation
and flagging the duplicate records to another target by
writing an expression in the exp editor
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain do we need an etl tool?
What is the difference between Data Warehousing and Data Mining?
what are the data modeling tools you have used?(polaris)
What do you understand by active and passive transformations?
Explain etl mapping sheets?
What are the etl testing operations includes?
What is full load & incremental or refresh load?
Difference between flat files and relational sources?
what are the session parameters? How do u set them?
Define Dynamic push down optmization?
What is data cleaning?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Difference between flat files and relational sources?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
