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
- 5932 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
How many steps etl contains?
What are snapshots?
What is lookup table in etl testing?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What is a mapping, session, worklet, workflow, mapplet?
how to load the data to fact table?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is the difference between project backlog and product backlog?
how do use session mapping parameters ?(in which transformation)
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
Explain what are the various etl tools in the market?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
how to connect to a flatfile through ftp in informatica
what is the main role of FI on business
how many steps are there in etl process?
