How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Answer Posted / chandu
we can achieve this by using first value or last value in lkp properties.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Session and Batches?
how many types of dimensions are available in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to create Target definition for flat files?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain what transformation and how many are there in informatica?
What are the restrictions of union transformation?
What does reusable transformation mean?
What are multi-group transformations?
what is the -ve test case in your project.
How can we update a record in the target table without using update strategy?
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,
In how many ways we can create ports?
Explain direct and indirect flat file loading (source file type) - informatica