what is distinct
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 |
How does the server recognize the source and target databases. Elaborate on this.
What are active transformations? Name them.
Difference between task flow and linear task flow
who to split dimentions into sub dimention
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
In real time scenario where can we use mapping parameters and variables?
what is casual dimension?
How to handle changing source file counts in a mapping?
What is domain and gateway node?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
which one is better either active or passive transformation in informatica
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?