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 / 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 |
Post New Answer View All Answers
what is INFORMATICA TESTING process
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Can we override a native sql query within informatica?
what is the size of your data warehousing?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Is it possible to create multiple domains on a single Informatica server?
How to load data in informatica ?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is a node in Informatica?
What is rank transform?
To import the flat file definition into the designer where should the flat file be placed?
What are the reusable transformations?
What are the measure objects?