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
- 7567 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 are the types of data warehouses?
What is a repository? And how to add it in an informatica client?
Define mapping and session?
What is the sequence generator transformation in informatica?
How to elaborate powercenter integration service?
Where can we find the throughput option in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Which development components of informatica have the highest usage?
Explain the different kinds of facts.
What is a grid in Informatica?
Explain transaction control transformation in informatica
complex mapping ur project u r invlve can u explain and give real time example give me ?
Difference between Data and Index Caches?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is a snowflake schema?
