How can you define a transformation? What are different
types of transformations in Informatica?
- 10 Answers
- 24245 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 |
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
Explain pushdown optimization $pushdownconfig parameter - informatica
explain about informatica server architecture?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what is incremental data aggregation?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
What is DR strategy for Informatica project?
Without using Lookup & Sequence Generator, How to generate Sequence?
how we can update a target table without update strategy and update override?
Teradata 
