how can one eliminate dupliacte data with out using
distinct option?
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 |
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is runtime variable?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
Explain what are the different versions of informatica?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
Write the prerequisite tasks to achieve the session partition?
Can we write to_date(three arguments) ? Will it work ? Advance thanks
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What are the types of error logs available in Informatica?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
What is standalone command task?