I have a Flat file with more no. of Records also including
duplicate values. But i need distinct values to one target and
remaining records to another target in Informatica way
- 2 Answers
- 5263 Views
- I also Faced
- E-Mail Answers
Answer Posted / naveen
1) use the router , create 2 diff groups
2) let both the groups have the same condition , eg: emp_id
> 1000 in both the groups. only then u will all the records
in both the groups
3) use a sorter or rank transformation to enable select
distinct option for the first group and send it to the
target
4) connect the second router group directly to the another
target
5) enjoy
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Two default user groups created in the repository are____and_____.
How to increase performance without changing anything in mapping.( In prod)
how do u handle performance issues in Informatica . where can u monitor the performance ?
What is staging area referring to?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain the difference between etl tool and olap tools?
How etl testing is different from database testing?
what is the difference steps for data modeling?
Which transformation we use to convert 'NA' to 'Not Available'
when will use SQL override in a lookup transformation?
where are the log files generally stored.Can you change the path of the file.what can the path be?
how do u set partition points in the mapping?
How to fine tune mappings?
What are cubes and olap cubes?
