Informatica interview questions

Comments (3)

4infadoubts in Falls Church, Virginia

59 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?

kinley in Princeton, New Jersey

58 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.

SARAVANA KUMAR NARENDRAN in Madras, India

43 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.

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