Answer Posted / vino
i Think,
You can split the dimension tables into two and can join
the two separate dimemsion tables by the surrogate key.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
What are the modules in Power Center
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain the different kinds of facts.
How can you generate reports in informatica?
Enterprise data warehouse your projects phase by phase explain?
Define pmcmd command?
Explain in detail scd type 2 through mapping.
How to do the error handling of if ur source is flatfiles?
What are the types of data warehouses?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Explain the scenario which compels informatica server to reject files?
Explain what are the different types of transformation available in informatica.
While migrating the data from one environment to another environment how would you manage the connections?
