Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 4 Answers
- 15450 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pooja ahmed
1. you can you use sorter transformation .... in that you
select distinct option
2. use agg trans .... in that go for group by
usi8ng above metyhod you can remove duplicate rec...
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What are dimensions?
what is data modeling?
how would u estimate the size of Aggregator transform data and index cache?
how to load the data to fact table?
list and discuss two approaches for updation of target table in Informatica and how they are different.
hoe to access second value in mapping parameter if it is having more than one value ?????????????
What are the modules in Power Mart?
What is staging area referring to?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is full load & incremental or refresh load?
Can there be sub steps of etl steps?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How etl testing is different from database testing?
State the differences between shortcut and reusable transformation
