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
- 6451 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
what is the Default Source Option For Update Strategy Transformation?
What is a snowflake schema?
What is meant by active and passive transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is informatica metadata and where is it stored?
Explain the code page compatibility?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Describe an informatica powercenter?
What are the performance considerations when working with aggregator transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the benefit of session partitioning?
Explain the difference between a data warehouse and a data mart?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the reusable transformations?
How do you remove duplicate records in informatica? And how many ways are there to do it?
