how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / sathish
put primary key to target it will reject duplicate rows
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Differentiate between reusable transformation and mapplet.
Explain informatica architecture - version 8 / 9
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is the difference between informatica 7.0 and 8.0?
Explain dynamic target flat file name generation in informatica
Which transformation should we use to normalise the COBOL and relational sources?
Is it possible to create multiple domains on a single Informatica server?
What are the types of data warehouses?
What is the commit type if you have a transaction control transformation in the mapping?
Explain why we use partitioning the session in informatica?
Scheduling properties,whats the default (sequential)
What are different types of transformations available in informatica?
How to do unit testing in informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Describe the impact of several join conditions and join order in a joiner transformation?