How can you define a transformation? What are different
types of transformations in Informatica?
- 10 Answers
- 24339 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 |
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
how to join the two flatfiles using the joiner t/r if there is no matching port?
How we will implement Pushdown Optimization and Types in Informatica with better examples
In informatics server which files are created during the session rums?
What is a joiner transformation?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
Explain about Informatica server process that how it works relates to mapping variables?
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
What is incremental aggregation?
What are junk dimensions?
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Teradata 
