Interested to Buy Any Domain ? << Click Here >> for more details...
how eliminate the duplicates in flat file with out using
sorter ,aggregater
- 4 Answers
- 11270 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
Where do we use mapping variables in informatica?
Define Pmrep command?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what is informatica metadata?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is target designer and target load order?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are some examples of informatica etl programs?
Explain about cumulative Sum or moving sum?
What is option by which we can run all the sessions in a batch simultaneously?
What is the way to execute pl/sql script using informatica mapping?
State the limitations where we cannot use joiner in the mapping pipeline?
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
Enlist the tasks for which source qualifier transformation is used.
Explain the code page compatibility?
