what is distinct

Answers were Sorted based on User's Feedback



what is distinct..

Answer / chandrasekar

DISTINCT is used to display the unique records.

Is This Answer Correct ?    5 Yes 0 No

what is distinct..

Answer / sudhakar

it will shown single time.
ex:-in accounts dept have 10 employees.
naturally
employee dept
sai acccouts
sudhakar accounts
ramesh accounts
etc.... upto 10members

like distinct show
department show single time
Employee Dept
10 accounts

Is This Answer Correct ?    1 Yes 0 No

what is distinct..

Answer / amol m

Distinct keyword is used to eliminate duplicate records and
showing only single one.

Is This Answer Correct ?    1 Yes 0 No

what is distinct..

Answer / alok

SELECT distinct * FROM STUDENT;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is mean by flag 4 in update strategy t/r

6 Answers  


What is the difference between procedure and stored procedur?

2 Answers   IBM,


In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,


where to select code page option?

2 Answers   TCS,


What is enterprise data warehousing?

0 Answers  






What are the differences between source qualifier and joiner transformation?

0 Answers  


How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,


i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,


How we can create indexes after completing the loan process?

0 Answers  


What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,


How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,


Categories