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

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

---

What is the difference between validated and compiled in the datastage?

0 Answers  

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

---

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

0 Answers  

---

Can you explain engine tier in information server?

0 Answers  

---

What are the different database update actions available?

1 Answers   HP,

---

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

---

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

---

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

5 Answers   IBM,

---

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me

0 Answers  

---