How can you define a transformation? What are different
types of transformations in Informatica?
- 7 Answers
- 8830 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
transformation is a component in informatica which help us
to transform data from one form to anthor
we have two types of transformation
1, active transformation
2,passive transformation
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / lakshmana rao
A Transformation is a process which recieves inputs and
transform into a desired output.
Two types of transformations.
1.Active Transformation
2.Passive Transformation
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / mohd atif
Transformation is defined as modulating the information.
There are two types of Transformation of information
1.Active
2.Passive
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rahul
a transformation basically is a mechanism which enables
transforming the data as per the business requirement.
for eg in the source database if the date is in the mm dd
yyyy format and in the target database the date is in dd mm
yyyy format,so we apply transformation to remove the
inconsistancy
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ankit kansal
Transformation in Informatica are set of components which have some specially defined functionality which is used to transform the data as per business needs.
1)Sorter-To sort the data.
2)Expression-heavily used to transform data type and perform several business logics
3)Aggregator
4)Rank ..e.t.c
deepinopensource.blogspot.in
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kallu bhai
Transformation is object,which can be used to devolop the
business logic for processing tha data.two types of
transformations is there.
1.active transformation
2.passive Transformation
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / pk
There is a free lesson on the Informatica aggregator
transformation on the home page of trainovation.com
| Is This Answer Correct ? | 1 Yes | 3 No |
What are parallel querys and query hints?
Explain what is the difference between datawarehouse and bi?
Explain what is metadata reporter?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is a relationship?
what are different ways of loading data to data warehouse using oracle?
What is difference macros and prompts?
What is the difference between dependent data warehouse and independent data warehouse?
What are algorithms provided by Microsoft in SQL Server?
Explain dimension table ?
What is aggregate awareness?
I know of using applysimple, but there are other ways too?
Teradata 
