Interested to Buy Any Domain ? << Click Here >> for more details...
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND
REMAINING TO OTHER TARGET?
- 6 Answers
- 11878 Views
- I also Faced
- E-Mail Answers
Answer Posted / narender.vankuri
Take an example:Dept table
Source->source Qualifier->After this we take one Aggregator and one Expression -> and both of this connected to Joiner -> this connect to Router->Here we take one Sequence generator and connect to Router-> this router connect to Targets
Here we see conditions:
1) In Aggregator create Cnt Port and(No input ,only output) There expression Condition(COUNT(DeptNo)
In this create One extra port Decimal express:1(no input,only output)
Disable Groupby
2) In Expression create one extra port decimal expression:1
this 2 transformations(Aggregator,Expression) are connected to Joiner
3)In Joiner Enable SorterInput,Condition And connect to Router Input.
4)Take one Sequence Generator and connect to Router Nextval
5)In Router Group1:Nextval<=(Cnt/2)
6)In Router Group2:Nextval>(Cnt/2)
7)Now connected to Traget1,Target2.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to create Target definition for flat files?
What are the performance considerations when working with aggregator transformation?
What is a repository? And how to add it in an informatica client?
What is decode in informatica?
How to load the data from people soft hrm to people soft erm using informatica?
In warehouses how many schemas are there?
Explain load alternative records / rows into multiple targets - informatica
Mention a few design and development best practices for informatica?
What is the commit type if you have a transaction control transformation in the mapping?
How to update or delete the rows in a target, which do not have key fields?
While migrating the data from one environment to another environment how would you manage the connections?
How we can create indexes after completing the load process?
