Answer / sriram

Database contains data called production data mostly and we can do operations but not recommended which is a performance issue and is always busy with application data
where as in DW,the data which we maitain is called historical data, on which we can play around.

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,

---

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,

---

Explain the ChangeApply stage?

11 Answers  

---

What is the default padding character?

3 Answers   IBM,

---

What is RCP?

2 Answers   TCS,

---

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

---

Can we use target hash file as a lookup ?

0 Answers  

---

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

Differentiate between datastage and datastage tx?

0 Answers  

---

How do you find the number of rows in a sequential file?

1 Answers  

---