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
- 25559 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 |
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
Is informatica power center designer has 64 bit support?
How many ways are there to create ports?
how can one eliminate dupliacte data with out using distinct option?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
Can you start a session inside a batch individually?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How would you copy the content of one repository to another repository?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the difference between stop and abort in informatica
Teradata 
