Interested to Buy Any Domain ? << Click Here >> for more details...
how eliminate the duplicates in flat file with out using
sorter ,aggregater
- 4 Answers
- 11215 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sanjay
here i m taking the example of employee table
first use the sorter to get the distinct value....
then use the agg trns, create the output port and use the
count function on employee_id to get the total no. of rows
like.. count(employee_id) and group by employee_id.
create filter trns.. write a condition where output>1... map
it with the target...
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What are the different components of powercenter?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
list out all the transformations which use cache?
Explain the types of transformations?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is meant by target load plan?
What is aggregate cache in aggregator transformation?
generate date / time dimension in informatica
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is blocking transformation?
Explain load alternative records / rows into multiple targets - informatica
Explain the features of connected and unconnected lookup.
What is different between the data warehouse and data mart?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is a rank transform?
