How can you define a transformation? What are different
types of transformations in Informatica?
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
How to handle multi value dimensions?
Explain dimensional modelling?
What is a view as it relates to system modeling?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
How to pivot data using informatica when you have variable amount of pivot rows?
What is edw?
Explain what is a three tier data warehouse?
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?
how much memory space occupied real time project (roughly)?
What is Active Datawarehousing?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Define data warehouse?
What is the goal of optimizer?
What are the different models used in cluster analysis?