how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 9528 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 |
What do you understand by a term domain?
What is Cognos script editor?
difference between repository database and repository service?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
what is lookup ?
What is the difference between lookup override and souce qualifier override ?
How do you change parameter when you move it from development to production.
what is index?how it can work in informatica
What is status code in informatica?
How many number of sessions that u can create in a batch?
Define Incremental Aggregation?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
Teradata 
