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
- 7347 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vijaya
above answer only for the first time data loading only for new
record inserts to source it gives false results
| Is This Answer Correct ? | 1 Yes | 4 No |
How do you take back up of repository?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
How to delete duplicate record in Informatica?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
Can yoU use the maping parameters or variables created in one maping into another maping?
can anyone explain me about retail domain project in informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to join three sources using joiner?
What is the function of look up transformation?
What are the prerequisite tasks to achieve the session partition?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Teradata 
