Explain what are the various transformation available?
No Answer is Posted For this Question
Be the First to Post Answer
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 operational data store (ods)?
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.
What is the difference between junk dimension and degenerated dimension?
Explain what are the advantages data mining over traditional approaches?
Explain when do we analyze the tables? How do we do it?
Explain what is fact less fact table? Where you have used it in your project?
How can you define a transformation? What are different types of transformations in Informatica?
What is application.cfm?
What is dimension modeling?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
What is the use of incremental aggregation? Explain me in brief with an example?