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
- 8923 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 |
performance wise which one is better in joiner and lookup transformation
What are the join types in joiner transformation?
Explain transaction control transformation in informatica
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
What is data transformation manager process?
How you count the number of records available at your source?
What is native users?
In ur current projectu have done any performance tuning of mappings?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is query panel?
Can you access a repository created in previous version of Informatica?
what is difference between dimention table and fact table?
Teradata 
