Answer / baskar

Transformation is define, Transform the source data
according to requirement of the target system.

Its two types 1-active Tran 2-passive Tran

Answer / tadikonda

transformation is a repositorty object,which transforms the
data as per requiremnt to load into target.
Transformations are two types
1)Active
2)Passive

Answer / steve

A transformation is a repository object that generates,
modifies, or passes data
Transformations in a mapping represent the operations the
Informatica Server performs on the data
It can be
Connected , unconnected , active or passive

Answer / rudresh

Transformation is a repositorty object,which loads the data
into target as per the busines rule.

Transformations are two types
1)Active
2)Passive

Answer / subrat

transformation is a repository object that allows us to
define a business logic in order to process the data.

can b of two types....active n passive

Answer / bobby

Transformation allow you to define transformation rules i.e.
business logic used for processing data.
There are 2 types of transformation they are:-
1.Active transformation
2.Passive transformation
1.Active transformation :- The number of rows which enter
the transformation is not same as number of rows exit the
transformation i.e chages occur.
2.Passive transformation :-The number of rows which enter
the transformation is same as number of rows exit the
transformation i.e chages does not occur.

Answer / k.pavan

transforamtion is a business logics, it transfers the data is call transformatio, transformations are different types these are in the given below.
1.filter .
2.expression.
3.router.
4.lookup.
5.joiner.
6.aggregator.
7.update strategy.
8.rank.
9.normalizer.
10.sequence generator.
11.source qualifier.
12.reusable.

Answer / shalijni

There are 6 kinds of transformation(3 pairs of discretion)::
Active and Passive
Connected and Unconnected
Cache and Non Cache creating(Sorry the exact name escapes
me at the moment)

Answer / kumar

laplace,inverse,z-trnsform

Answer / vijay reddy

transformation is which type of table col do you want in
source table to target then u use transformations.
transformations are various types.
1. sequential qualifier trans
2. lookup trans
3. Expression trans
4. Rank trans
5. Sequential trans....etc

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

What is DR strategy for Informatica project?

0 Answers  

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

what is the gap analysis?

1 Answers  

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

What is rank index in rank transformation?

0 Answers  

Reusable transformation and shortcut differences

0 Answers  

What is a joiner transformation?

0 Answers