Is snow flake or star schema used?
If star schema means why?
Answer Posted / koti
star schema is for simple data marts where as snowflake
schema for complexives...
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the commit type if you have a transaction control transformation in the mapping?
How would you copy the content of one repository to another repository?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Briefly define reusable transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain what are the different types of transformation available in informatica.
Explain pmcmd command usage in informatica
In which transformation you cannot drag ports into it?
Please let me know how to make encryption and decryption with example?
What is workflow monitor?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How many transformations can be used in mapplets.
What does cheating measurement mean?
Please let me know how to make Data masking in informatica..
What are the advantages of using informatica as an etl tool over teradata?