Interested to Buy Any Domain ? << Click Here >> for more details...
what is distinct
- 4 Answers
- 6051 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
DISTINCT is used to display the unique records.
| Is This Answer Correct ? | 5 Yes | 0 No |
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 |
Answer / amol m
Distinct keyword is used to eliminate duplicate records and
showing only single one.
| Is This Answer Correct ? | 1 Yes | 0 No |
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
What are limitations of joiner transformation?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Why is sorter an active transformation?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
How does the server recognize the source and target databases. Elaborate on this.
What is an expression transformation?
EXL informatica Questions
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
Teradata 
