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 are the data movement modes in informatcia?

1 Answers  


if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,


what is the difference between stop and abort

2 Answers  


Explain target update override in informatica

0 Answers   Informatica,


What is a snowflake schema?

0 Answers  






What are the uses of etl tools?

0 Answers  


How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

0 Answers   TCS,


what are the row and column separations in Flat Files

3 Answers   CTS,


How does the server recognize the source and target databases. Elaborate on this.

1 Answers  


If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,


Categories