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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Slowly changing dimensions, types and where will you use them
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Write the prerequisite tasks to achieve the session partition?
What is the difference between informatica 7.0 and 8.0?
According to his methodology what all you need before you build a datawarehouse
Performance tuning( what you did in performance tuning)
What is informatica?
What is the session task and command task?
what is the difference between informatica6.1 and infomatica7.1
Why do you use Mapping Parameter and mapping variable?
what is the -ve test case in your project.
What is domain and gateway node?
What is session task and command task?
Did u used latest transformations of 8.6.0? for what?
