Interested to Buy Any Domain ? << Click Here >> for more details...
how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 10759 Views
- Patni, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the pipeline partition with real time example?
How many types of sessions are there in informatica.please explain them?
Explain dynamic target flat file name generation in informatica
What is aggregator transformation in informatica?
What are the uses of etl tools?
What is lookup change?
How do you load alternate records into different tables through mapping flow?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are Dimensional table?
How to update or delete the rows in a target, which do not have key fields?
What are the different options available for update strategy?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How we can create indexes after completing the load process?
