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
- 7566 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 |
what is diff b/t sorter t/r and agg have the option sorter property...
Different sorts of metadata that stores in the storage facility?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
What is rank index in rank transformation?
how to join the two flatfiles using the joiner t/r if there is no matching port?
What is dimensional table? Explain the different dimensions.
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
What is joiner transformation?
how DTM buffer size and buffer block size are related
How do you join more than 3 flat files in informatica?
why we use stored procedure transformation?
What is target load order?
Teradata 
