Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records in a flat file source?
- 2 Answers
- 8646 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
conncet the flat file to sorter transformation and select
distinct option.
| Is This Answer Correct ? | 17 Yes | 6 No |
Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How do you migrate data from one environment to another?
What is the need of building a data warehouse?
what is the predefined port in dynamic lookup
server hot-ws270 is connect to Repository B. What does it mean?
Explain the different lookup methods used in informatica?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
sorce is a flatfile only 1st and last row should insert to target how will u do?
What is the Rankindex in Ranktransformation?
Can you copy the session to a different folder or repository?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
What is deployment group?
Teradata 
