-
Loading data to multiple targets
how to create mapping that half records will go to one target and half to another target?
vijayant.sanjay
- Sep 7th, 2011
Use the sql override in source qualifier as select col1, col2, (select count(*) from table) from table;
In the mapping flag the rows into groups in router t/f as count(*) port count(*)/2sivakp
- Mar 13th, 2011
Create two source qualifier write a query in SQL override select * from emp where rownum in(select count(*)/2 from emp)another
SQL override write a queryselect * from empminusselect * from emp where rownum in(select count(*)/2 from emp)
To connect target -
Aggregate Value
Explain a mapping design to start aggregating the values before getting all the rows from the source.
vijayant.sanjay
- Sep 7th, 2011
Agg t/f when using unsorted data, it do not perform agg calculation until it receives all the source rows from the pipeline, on the other hand when using sorted data for Agg t/f agg calculation starts...
jayapraveen
- Oct 4th, 2010
Here we taken this context as two ways aggregate value means for example if we take sales sum(sales)min(sales)max(sales)and the second context isfor the better performance we use the sorter before aggregator incoming values of the source
-
Update Strategy Transformation
Why the input pipe lines to the joiner should not contain an update strategy transformation?
vijayant.sanjay
- Sep 7th, 2011
Joiner will join two groups of data either homogeneous or heterogeneous, and this join will happen horizontally. One scenario why use of update strategy is prohibited upstream of joiner t/f as below ...
Etl Developer
- May 28th, 2010
This scenario is illogical, First we need to understand the functionality of each repository object.Update strategy: This transofrmation is used to maintain the transaction data based on differen...
-
Convert Source Column into Target Rows
What transformation do you use to convert source column into target rows? Explain
vijayant.sanjay
- Sep 7th, 2011
Normalizer is basically used to convert rows to columns. I don't think alone normalizer is sufficient to convert columns into rows. In certain scenario you use this sequence of t/f to convert columns ...
Ishaan_Kulshrestha
- Apr 14th, 2010
Hi Sahan,Please let me know how aggregator is used here. I think Aggregator is required when we denormalise data and here our requirement is to Normailse the data.Please correct me if I am wrong. Thanks
-
