Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
- 6 Answers
- 10090 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
First we can count the no of records using aggregator
Transformation with group by (port) for ex, in emp table
take empno. Second we can take the Filter condition like
count=1. Other records are rejected not loaded into the target.
Hope it will help little bit...
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
expain about the tune parameters?
Define filter transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Partition, what happens if the specified key range is shorter and longer
What is the format of informatica objects in a repository?
What will be the approach?
What do you understand by SOA of Informatica?
What is domain in terms of informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the advantages of informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How do you set a varible in incremental aggregation
Differences between connected and unconnected lookup?
What is data transformation manager process?
