Answer / suresh

above answer is wrong,correct answer is converting denormalized data into normalized data is called snow flake schema

Answer / srinu

one fact table is surrounded by different dimension table
and dimension table relation with master dimension table is
called snowflake schema (or) extended star schema

how to handle null values in sequential file?

1 Answers   HCL,

---

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

---

What are orabulk and bcp stages?

0 Answers  

---

How did you reconcile source with target?

3 Answers   HP,

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

What is the difference between lookup and sparse lookup?

1 Answers  

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  

---

source contains 2 columns comes to target 4 columns how

1 Answers   IBM,

---

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

---