ETL - What are the various transformation available?

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 7 of 65

What are the various transformation available?

Total Answers and Comments: 9

Last Update: November 24, 2008

Sponsored Links

Best Rated Answer

—

Submitted by: krishi

the various type of transformation in informatica
source qualifier
aggregate
sequence generator
sorter
router
filter
lookup
update strategy
joiner
normalizer
expression

Above answer was rated as good by the following members:
dgerundo, Swathi.M, mdusane

April 21, 2005 20:53:40

krishi

RE: What are the various transformation available?

the various type of transformation in informatica
source qualifier
aggregate
sequence generator
sorter
router
filter
lookup
update strategy
joiner
normalizer
expression

Is this answer useful? Yes | No

3 0

Overall Rating: +3

June 23, 2005 20:29:57

Rajesh

RE: What are the various transformation available?

Hi

Transformation plays an important role in Datawarehouse. Transformation are used when data is moved from source to destination. Depding upon crieteria transformations are done. Some of the transformations are Aggregater Lookup Filter Source Qualifier Sequence Generator Expression

Is this answer useful? Yes | No

July 07, 2005 01:44:00

Ramesh

RE: What are the various transformation available?

Aggregator Transformation
Expression Transformation
Filter Transformation
Joiner Transformation
Lookup Transformation
Normalizer Transformation
Rank Transformation
Router Transformation
Sequence Generator Transformation
Stored Procedure Transformation
Sorter Transformation
Update Strategy Transformation
XML Source Qualifier Transformation
Advanced External Procedure Transformation
External Transformation

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 26, 2005 22:27:18

P.C.LOKNATH

RE: What are the various transformation available?

SOURCE QUALIFIER
AGGREGATOR
UPDATE STRATEGY
EXPRESSION
STORED PROCEDURE
SEQUENCE GENERATOR
FILTER
LOOKUP
JOINER
ROUTER
RANK
XML SOURCE QUALIFIER
MQ SERIES SOURCE QUALIFIER
SORTER
APPLICATION MULTI GROUP
TRANSACTION CONTROLLER
MAPPLET INPUT
MAPPLET OUTPUT
NORMALIZER

Is this answer useful? Yes | No

August 17, 2005 19:36:40

Sriharsha Hanumanth

RE: What are the various transformation available?

Various transforamtions available irrespective of what tool you are using:
Roll-up
Drill-down
Slice and Dice
Pivot

Is this answer useful? Yes | No

November 01, 2005 09:03:53

Ravi

incremnetla valuesOr Sequnce genrator

how to use the sequnce genrator on datastage

Is this answer useful? Yes | No

December 29, 2005 19:34:23

bvrp

RE: What are the various transformation available?

Over all 19 transformations are available in Informatica and they are as follows: Source Qualifier Aggregator Update Strategy Expression Stored Procedure Sequence Generator Filter Lookup Joiner Router Rank Xml Source Qualifier MQ Series Source Qualifier Sorter Application Multi Group Transaction Controller Mapplet Input Mapplet Output Normalizer

Is this answer useful? Yes | No

February 16, 2007 05:15:41

naveen

RE: What are the various transformation available?

can u plz send the detailed description of each transformationthanx

Is this answer useful? Yes | No

November 24, 2008 11:06:51

snareshinfo

Member Since: July 2008 Contribution: 2

RE: What are the various transformation available?

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank