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
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to create a non-reusable instance of reusable transformations?
What are the types of presistent cache in look up tr.
What is difference between a gateway node and worker node?
What are mapplets?
What are the advantages of using informatica as an etl tool over teradata?
Can anyone tell me the new features in Informatica 9 Version?
As union transformation gives UNION ALL output, how you will get the UNION output?
without table how to come first record only in oracle?
Differentiate between reusable transformation and mapplet.
How to improve the performance of a session using sorter transformation?
Write the prerequisite tasks to achieve the session partition?
what are the Methods For Creating Reusable Transformations?
What is rank index in rank transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?