what is normalization and denormalization
Answers were Sorted based on User's Feedback
Answer / somu
IN Normalization is controlled by elimination redundant
data where as in Denormalisation is controlled by redundant
data.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shanu
Normalisation is a Process of decomposing the tables into
number of succesive tables to avoid Data Retundancy and
Inconsistency
| Is This Answer Correct ? | 0 Yes | 0 No |
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
How and where you used hash file?
What are some prerequisites for datastage?
Main Function of the Staging area in DWH ?
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
Could anyone give brief explanation bout datastage admin
How a source file is populated?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
Triggers,VIEW,Procedures
What is difference between symmetric multiprocessing and massive parallel processing?
Can you explain link buffering?