Interested to Buy Any Domain ? << Click Here >> for more details...
i have 2 flat files one table contains duplicates another one
no duplicates.... so i need like this i don't want
duplicates...pl's give me ans...
- 4 Answers
- 8788 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / teja
place sorter transformation after source qualifier of duplicates flatfile and enable property distinct
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / guest
with the help of joiner transformation we can join these two
flat file sources and reject the duplicate rows using normal
join in joiner transformation
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / ankit kansal
Hi Gow,
As Question specified there are two source files so you can not user Distinct clause in Source Qualifier.
http://deepinopensource.blogspot.com/
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / gow
Hi Teja
We can use distinct option in source qualifier of the table having duplicate records itself right? Why do we need to use sorter after the source qualifier?.
Please correct me if i am wrong.
| Is This Answer Correct ? | 0 Yes | 3 No |
what are the types of facts with Examples?
Explain about Recovering sessions?
What does cheating measurement mean?
How can we delete duplicate rows from flat files?
what is flat file override?
Can you create a flatfile target
What is use of batch file in informatica? How many types of batch file in informatica?
Differentiate between router and filter transformation?
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
What r the type of indexes u generally used in informatica?
what is the method of error handling when session is running?
What is the use of transformation?
Teradata 
