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
Explain what are the different types of transformation available in informatica.
Explain the informatica workflow?
What are the limitations of joiner transformation?
Explain sessions and how many types of sessions are there?
Explain how many types of dimensions are available in informatica?
What is meant by query override?
What are the prerequisite tasks to achieve the session partition?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Define Pmrep command?
What is the difference between Active and Passive transformation?
What is blocking transformation?
Briefly define a session task?
To import the flat file definition into the designer where should the flat file be placed?
Global and Local shortcuts. Advantages.
What is the Process to creating lookup transformation in informatica