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 procedure for creating independent data marts from informatica 7.1?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Is there any target staging area in informatica not staging area
What are the types of lookup transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Please let me know how to make Data masking in informatica..
what is the complex transformation you used in informatica
What is confirmed fact in dataware housing?
Differentiate between sessions and batches?
What is decode in static cache?
What does reusable transformation mean?
Is it possible to define a single node as a Gateway node as well as worker node?
Define Pmrep command?
What is a connected transformation?
What is workflow monitor?