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...
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
How do you load alternate records into different tables through mapping flow?
What is informatica metadata and where is it stored?
How many ways are there to create ports?
How are the sources and targets definitions imported in informatica designer?
what are the Methods For Creating Reusable Transformations?
Enlist some properties of sessions.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
In how many ways we can create ports?
What is Index Caches size?
What is incremental aggregation?
COM components can be used in Informatica
What is the session task and command task?
What are roles and groups and benefits of using them?
Which transformation should we use to normalise the COBOL and relational sources?