Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15440 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
what is dynamic insert?
what is pmrep command?
When do we go for the tools in the market?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Explain about enterprise scalability and roi of data integration suite?
What is the difference between Data Warehousing and Data Mining?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
what is the meant by Normalization and de-normalization?
What are various etl tools in the market?
What is etl process? How many steps etl contains?
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?
State the differences between shortcut and reusable transformation
What is partitioning? Explain different types of partitioning?
What is virtual Data Warehousing?
Explain the difference between etl tool and olap tools?
