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 |
What are the components of datastage?
What is the default padding character?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
how to capture rejected data by using join stage not for lookup stage. please let me know
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
Define Job control?
Unix command to view the data in a dataset
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
Describe stream connector?
what is normalization and denormalization
In merge stage can we update the values?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.