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
- 6461 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 |
I have a flat file, want to reverse the contents of the flat file
How will you update the row without using update statergy?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
What do you mean incremental aggregation?
What are the types of caches in lookup? Explain them.
how can we calculate fact table size?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
Write the program through which the records can be updated?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the designer tools for creating tranformations?
What is an aggregator transformation? it is active why cant it be passive explain?
Teradata 
