How can you define a transformation? What are different
types of transformations in Informatica?
Answer Posted / 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 |
Post New Answer View All Answers
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is an er diagram?
What is scd1 , scd2 , scd3?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
How to add a number to a macro variable?
Briefly state different between data ware house & data mart?
What is load manager?
Explain can report net connect multiple datasource at a time in report creation time?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Explain what are the vaious etl tools in the market?
Explain which columns go to the fact table and which columns go the dimension table?
What is MODEL is Data mining world?
What is the data type of the surrogate key?