Interested to Buy Any Domain ? << Click Here >> for more details...
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
- 2 Answers
- 7446 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / narender.vankuri
Hi am Narender Reddy 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.
ThankYou
V.Narender Reddy
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the popular informatica products?
draw informatica architecture 8.6 ?
What is informatica?
What is an aggregator transformation?
can we override a native sql query within informatica? Where do we do it?
how we can load rejected record's at run time?(not through bad files)
Can you generate sequence numbers without using the sequence generator transformation?
What is the difference between informatica 7.0 and 8.0?
Explain how many types of dimensions are available in informatica?
Explain sql transformation in script mode examples in informatica
What is the scenario which compels informatica server to reject files?
Explain the types of transformations?
What are the tasks that source qualifier perform?
