select id from tgt_table group by id;

write a query for how to eliminate the duplicate rows
without using distinct?

Question Posted / abhishek kumar

Answer Posted / abhishek kumar

Is This Answer Correct ?

7 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain in detail about scd type 1 through mapping.

1555

What is Cognos script editor?

4235

What are the guidelines to be followed while using union transformation?

1144

In informatics server which files are created during the session rums?

1115

Under which circumstances, informatica server creates reject files?

1095

what is degenerated dimension?

3998

How can we improve session performance in aggregator transformation?

1117

How to load a Dimension ? and how to load a fact table?

1418

where to store informatica rejected data? How to extract the informatica rejected data?

1007

How to convert multiple rows to single row (multiple columns) in informatica

1383

Enlist the various types of transformations.

1057

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1134

Explain sessions and how many types of sessions are there?

1011

Can you generate sequence numbers without using the sequence generator transformation?

1123

What are the different ways to implement parallel processing in informatica?

1423