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...
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 do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
What is meta data and system catalog?
What is the benefit of partitioning a session?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
what is mean by flag 4 in update strategy t/r
What is junk dimention?
Explain how to import oracle sequence into informatica?
Differentiate between mapping parameter and mapping variable?
How to update or delete the rows in a target, which do not have key fields?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
Can you use the maping parameters or variables created in one maping into any other reusable transformation?