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 |
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
How many number of reject links merge stage can have?
How can one find bugs in job sequence?
Lookup constraints
Is possible to create skid in dim,fact tables?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
what r the sources u need to create the datastage?
what is initial load and incremental load
How to read the length of word in unix?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Explain entity, attribute and relationship in datastage?
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz