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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
how would u estimate the size of Aggregator transform data and index cache?
What are the various tools used in etl?
What are your responsibilities as an etl tester?
what are the data modeling tools you have used?(polaris)
what is session partitioning?
Do we need an etl tool?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
how do u set the size of block buffer?
what is SMP AND MPP?
What is the difference between project backlog and product backlog?
In Which Transformation We Can Use Having Clause In Informatica?
what is dynamic insert?