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
- 10234 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
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain the shared cache and re-cache?
How might you approve all mappings in the archive all the while?
Describe an informatica powercenter?
What are the data movement modes in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is different between the data warehouse and data mart?
What is the Process to creating lookup transformation in informatica
In how many ways we can create ports?
list out all the transformations which use cache?
In development project what is the process to follow for an etl developer from day1
How to load the data from people soft hrm to people soft erm using informatica?
What do you understand by term role-playing dimension?
write a query to retrieve the latest records from the table sorted by version(scd)
