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
- 5824 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?
dimension object created in oracle can be imported in designer?how?
Can there be sub steps of etl steps?
What are the different etl testing categories as per their function?
Can we create Hierarchies in generic datasources?
how many maximum session supports to multiload in teradata ??
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What is full load & incremental or refresh load?
State the differences between shortcut and reusable transformation
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is lookup table in etl testing?
Explain do we need an etl tool? When do we go for the tools in the market?
what is granularity in Data ware House?
What is data cleaning?
Explain different types of partitioning?
