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
What is the Rank index port in Rank transformation?
What differs when we choose the sorted input for aggregator transformation?
How to create the source and target database connections in server manager?
What is workflow? What are the components of workflow manager?
What is joiner transformation in informatica?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the modules in Power Center
Write the program through which the records can be updated?
What is the meaning of up gradation of repository?
What is parallel processing in informatica?
Explain lookup transformation in informatica
What is the need of etl tools?
How big was your fact table
Explain incremental aggregation in informatica
How to generate or load values in to the target table based on a column value using informatica etl tool.