How can you define a transformation? What are different
types of transformations in Informatica?
Answer Posted / 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 |
Post New Answer View All Answers
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
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?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What are the design methods of data warehousing?
ware house management system is used?
How to export mappings to the production environment?
What are parallel querys and query hints?
How can you communicate with web server (apache or iis) from coldfusion?
Explain what is difference between query studio and report studio?
What is vdl (view definition language) explain?
Explain what are fact, dimension, and measure?
Briefly state different between data ware house & data mart?
Why we use repository connectivity?
How much data hold in one universe.