-
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...
-
Passive Router Transformation
Router is passive transformation, but one may argue that it is passive because in case if we use default group (only) then there is no change in number of rows. What explanation will you give?
Read Best Answer
Editorial / Best Answer
sasi.a.kumar- Member Since Aug-2009 | Aug 14th, 2009
Router is an Active Transformation, Most of the time we use router only when we are going to apply multiple conditions on a records, It is absolutely possible for a record to satisfy one or more conditions thus making the router Active, Router is the only active transformation where the number of output records from the transformation is greater or equal to the number of input records given to the transformation.
bosna
- Aug 17th, 2011
AS PER INFORMATICA DOCUMENTATION, Router transformation is ACTIVE and CONNECTED.. Please Don't thumb down if you're not sure..
RANJAN RASMI DAS
- Jan 12th, 2011
Router can act both active and passive, one example....Suppose in source we have recordsid.....name -----------10.....aa10.....bb20.....cc20.....dd30.....xx40.....yy We have one target table...
-
What are Dimensions and various types of Dimensions?
set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.
Read Best Answer
Editorial / Best Answer
ManishTewatia- Member Since Jul-2010 | Jul 22nd, 2010
What Md.Rehman is trying to say is catagorizing the SCD which are the Slowly Changing Dimensions which are used to maintain historical data.
Dimension:A dimension is an organized hierarchy of categories, known as levels, that describes data in data warehouse fact tablesThe various types of dimensions are :
1) Shared and Private Dimensions: Describes the basic differences between shared and private dimensions and their uses
2) Regular Dimensions: Provides information about regular dimensions and their variations
3) Parent-Child Dimensions: Describes the creation of parent-child dimensions and identifies their advantages and restrictions
4) Data Mining Dimensions: Describes the creation of data mining dimensions and identifies advantages and restrictions to their use
5) Virtual Dimensions:Describes the creation of virtual dimensions and their advantages and restrictions
6) Dependent Dimensions: Describes the creation of dependent dimensions and identifies their advantages and restrictions
7) Write-Enabled Dimensions: Describes the creation of write-enabled dimensions and identifies their advantages and restrictions
VIKRAM KUMAR
- Mar 1st, 2018
Dimensions are of several types but we use few commonly which are, 1. Confirmed dim. dim. shared by all fact tables. ex- time dim. 2. Slow changing dim. it is of 3 types : SCD1. SCD2, SCD3., 3. Role ...
Venu Gaddam
- Dec 23rd, 2010
Dimensions are of 3 types mainly in case of slowly changing dimensions: Type 1 -> Does not maintain any history and is update only. --> this is normal practice mappings.Type 2-> Maintains full histor...
-
What are Aggregate transformation?
Aggregator transformation allows you to perform aggregate calculations, such as averages and sums.
Read Best Answer
Editorial / Best Answer
Answered by: Praveen vasudev
- Sep 12th, 2005
Aggregator transform is m uch like the Group by clause in traditional SQL.
this particular transform is a connected/active transform which can take the incoming data form the mapping pipeline and group them based on the group by ports specified and can caculated aggregate funtions like ( avg, sum, count, stddev....e.tc) for each of those groups.
From a performanace perspective if your mapping has an AGGREGATOR transform use filters and sorters very early in the pipeline if there is any need for them.
veepee
sivakp
- Mar 13th, 2011
1. Aggrigator transformation allows to perform aggrigate calculation, such as SUM, MAX, MIN, FIRST, LAST2. Aggrigator transformation allows to perform aggrigate calculation of group.
shr_4
- Oct 27th, 2010
To perform Group by calculations we use Aggregator Transformation.It perform calculations similar to Expression Transformation.But difference between both is that Aggregator Transform...
