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 are the validations that you can perform in oracle and in informatica ? Advance Thanks
How many dimensions are there in informatica?
What is exclusive and normal mode for repository services?
How many ways are there to do 'remove duplicate records in informatica'?
In informatics server which files are created during the session rums?
Can anyone tell me the new features in Informatica 9 Version?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are the new features of informatica 9.x at the developer level?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
In development project what is the process to follow for an etl developer from day1
How many transformations can be used in mapplets.
What are the tasks that can be performed using sq?
Can we create multiple integration service on single repository?
How can repository reports be accessed without sql or other transformations?
