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

If informatica has its scheduler why using third party scheduler?

0 Answers  


What is a repository manager?

0 Answers  


How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,


What is a command that used to run a batch?

4 Answers  


explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,






What is informatica metadata and where is it stored?

0 Answers  


What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,


wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,


what is the exact meaning of domain?

3 Answers  


How is Data Models Used in Practice?

1 Answers  


1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,


Categories