Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / navin
DW is for to maintain historical & current data.
if use Natural key as primary key in DW we can't maintain
history.so we need a physical key in DW i.e is generated by
ETL developer .In DW we have develop a key called surrogate
key.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Explain datastage architecture?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the method of removing duplicates, without the remove duplicate stage?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is ds designer?
Differentiate between datastage and datastage tx?
What are some prerequisites for datastage?
Why do we use exception activity in Datastage?
How do you generate sequence number in datastage?
Define repository tables in datastage?
What are the different layers in the information server architecture?
What a datastage macro?
How to Remove Duplicate using SQL?
