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 do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

Can i create a lookup table without cache.

7 Answers   iGate,

i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

what is update strategy transformation ?

7 Answers   TCS,

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,