Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5819 Views
- I also Faced
- E-Mail Answers
Answer Posted / naveen
1)Use a router , create 2 different groups
2) let both the groups have the same condition in it . eg:
if ur source have got emp _id column and the max value in
it is 1000. Let ur condition in the router be emp_id <= 1000
3) remember , u put both the conditions in the router are
same . Because only then both the groups will fetch full
set of records , eg , if 100 records are ther in the
source , u can get 200 records from these 2 groups totally
4) from the first group, link a sorter or rank
transformation , enable select distinct in that and pass it
to the target
5) connect the other group from the router directly to
another target.
6) enjoy
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can there be sub steps of etl steps?
Define Dynamic push down optmization?
where is the cache (lookup, index) created and how can you see it.
What are the etl testing operations includes?
what is Forward,Reverse and Re_engineering?
what is Forward,Reverse and Re_engineering?
Explain about power designer data modeling software?
What are cubes and olap cubes?
flat filevalidation in informatica
what is the difference steps for data modeling?
what do u do when DB time takes more?in sap bi
What is the difference between Data Warehousing and Data Mining?
what is pmrep command?
what is session partitioning?
what is granularity in Data ware House?
