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 export or import the jobs in .ISX file

0 Answers  

---

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---

how to delete one row in target dataset

0 Answers   Satyam,

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,

---

what is repositery?

0 Answers   IBM,

---

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

---

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

---

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

---

Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,

---