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

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

2 Answers  

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

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  

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

What is a grid in Informatica?

0 Answers  

Differentiate between router and filter transformation?

0 Answers