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 |
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
Differentiate between operational datastage (ods) and data warehouse?
Why do you need stage variables?
What are some different alternative commands associated with "dsjob"?
What all are the different way to run a job?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
why do u need the IOS upgradation in a FC switch
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
EXPLAIN SCD
whom do you report?
How a source file is populated?