Informatica interview questions

Get new comments by email
You can cancel email alerts at anytime.
Comments (3)

4infadoubts in Falls Church, Virginia

45 months ago

If a flat file is given as source to a mapping and the target data has to be distinct rows, how do we achieve this in informatica mappings?

- Was this comment helpful? Yes (14) / No (1) Reply - Report abuse

kinley in Princeton, New Jersey

45 months ago

There is no way to do a SELECT DISTINCT directly from a flat file; however you can use the "Distinct" option in a Sorter transformation.

Another alternate option is to create a mapping that loads the flat file data to a staging table. The next mapping would be able to do a SELECT DISTINCT from this relational staging table.

Or use an aggregator.

- Was this comment helpful? Yes (2) / No Reply - Report abuse

SARAVANA KUMAR NARENDRAN in Madras, India

30 months ago

HI,
In this u can't use SQ.
1)Either use sorter and select distinct in it.(best and save time)
or
2)use an aggregator and group by option.

- Was this comment helpful? Yes (2) / No (1) Reply - Report abuse

» Sign in or create an account to comment on this topic.