Interested to Buy Any Domain ? << Click Here >> for more details...
how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 10899 Views
- Patni, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
By using aggrator select groupby port to eliminate
duplicates
| Is This Answer Correct ? | 31 Yes | 0 No |
Answer / prabha kamaraj
Using Group by command removes all duplicates records in a
table
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sujatha
in the sq data has to be order by key column..then in the
expression trans we have to create a variable port to hold
the previous records key value...and one more variable port
to compare with the current records key value...if the prev
and curr are equal then the 2nd variable value will
get 'Y',if not equal its value will be 'N'.
Take a router ,process the rows which are having the 2nd
variable value as 'N' to the target....these are unique recs
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ankit kansal
An Alternative way
Using Rank Transformation select group by all and only select only those rows whose indexes are one.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / arpan
U can use Sorter Transformation and there is an option as
Select Distinct.
| Is This Answer Correct ? | 3 Yes | 6 No |
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
While importing the relational source definition from the database, what are the metadata of source that will be imported?
why we use datawarehouse
What is different between the data warehouse and data mart?
what are the output files that the informatica server creats during running a session?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
How do you set a varible in incremental aggregation
What are the tuning techniques you applied during your last project
What are the types of maping wizards that r to be provided in Informatica?
how can we use sorter transformation in joins?
How we will implement Pushdown Optimization and Types in Informatica with better examples
how to create a sample mapping for dynamic lookup transformation
Teradata 
