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
What is the benefit of partitioning a session?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is xml source qualifier transformation in informatica?
What are the designer tools for creating transformations?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to elaborate powercenter integration service?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
can we override a native sql query within informatica? Where do we do it? How do we do it?
Can we override a native sql query within informatica?
What is dimensional table?
What could be the possible resons of locks by user?
What are the settings that you use to configure the joiner transformation?
How to extract the informatica rejected data?
Is there any target staging area in informatica not staging area
How to update source definition?
