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
- 11690 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
What does role playing dimension mean?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Informatica settings are available in which file?
In how many ways we can create ports?
What is a predefined event?
What does cheating measurement mean?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Explain in detail about scd type 1 through mapping.
On which transformations you created partitions in your project?
Is it possible to define a single node as a Gateway node as well as worker node?
whats the logic to load the lower level of granularity of data to fact table.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to convert multiple rows to single row (multiple columns) in informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is DR strategy for Informatica project?
