Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15270 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bhagya
1) By enabling the option in sorter transformation as
select distinct
(or)
2) By enabling all the values as group by in aggreagator
transformation
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain about the data integration suite features?
What is Data Vault???
What are the three tiers in etl?
how do u really know that paging to disk is happening while u are using a lookup transform?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is tracing level and what are the types?
What is meant by incremental load?
what is data modeling?
What are the various tools used in etl?
what is session partitioning?
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.
Two default user groups created in the repository are____and_____.
how many maximum session supports to multiload in teradata ??
Define slowly changing dimensions (SCD)?
What is the difference between Data Warehousing and Data Mining?
