Interested to Buy Any Domain ? << Click Here >> for more details...
How can you define a transformation? What are different
types of transformations in Informatica?
- 10 Answers
- 25479 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 34 Yes | 8 No |
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
| Is This Answer Correct ? | 25 Yes | 5 No |
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
| Is This Answer Correct ? | 13 Yes | 5 No |
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
| Is This Answer Correct ? | 10 Yes | 4 No |
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.
| Is This Answer Correct ? | 9 Yes | 3 No |
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.
| Is This Answer Correct ? | 3 Yes | 1 No |
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)
| Is This Answer Correct ? | 1 Yes | 0 No |
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
| Is This Answer Correct ? | 16 Yes | 30 No |
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
what is the difference between repository & Intergration service
wt is Dynamic lookup Transformation? when we use?how we use?
why we are using surogate key in real time give me explanation
what is left outer join?
How to create Target definition for flat files?
How do we implement materialized view?when to use materialized view?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
difference between informatica 8.1.1 and 8.6
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Teradata 
