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
- 8597 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 |
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
What is the target load order?
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
What is critical mapping?
How to handle changing source file counts in a mapping?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
Can we run session without using workflows?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
Plz..let me know differences between Informatica 7.1 and 8.1?
Teradata 
