Answer / somu

IN Normalization is controlled by elimination redundant
data where as in Denormalisation is controlled by redundant
data.

Answer / shanu

Normalisation is a Process of decomposing the tables into
number of succesive tables to avoid Data Retundancy and
Inconsistency

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

0 Answers  

---

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

---

which is the most complex job in your career? Please tell me answer?

2 Answers   IBM, Wipro,

---

Is the value of staging variable stored temporarily or permanently?

0 Answers  

---

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

2 Answers   Wipro,

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---

difference between function and procedure...

1 Answers   IBM,

---

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

---

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

---