Interested to Buy Any Domain ? << Click Here >> for more details...
how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 10708 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 |
how can we load starting with 11th record of a table from source to target
What is transformation?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
When will you use SQL override in a lookup transformation?
connected and unconnected lookups?
What are the different options used to configure the sequential batches?
What are multi-group transformations?
What are the methods for creating reusable transforamtions?
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
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
Limitation of REPLACESTR. Is there any character limitation to it.
Teradata 
