Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swagatika
IN DWH environment,Every dimension table is integrated with surrogate key,which is byforced created to maintain the consistancy of data warehouse targets.It never generate the alfa numeric number of primary key & also replace the missing values.
The natural primary key ,which is coming from database is considered as alternate key in DWH Environment
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe expression transformation?
How big was your fact table
How to join three sources using joiner?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Difference between Target-based loading and constraint-based loading?
What is domain and gateway node?
Different qualification between a related rotate toward the sky and isolates look upward?
What are the different options available for update strategy?
How do you change a non-reusable transformation to reusable transformation?
How would you copy the content of one repository to another repository?
Briefly explain the aggregator transformation?
What's the layout of parameter file (what does a parameter file contain?)?
What are some examples of informatica etl programs?
What is an aggregator transformation?
Did u used latest transformations of 8.6.0? for what?
