Answer / sudhakar

the main disadvantage of snowflake schema is its normalised
format, so performance is poor and it is complex.

Answer / kishore

snowflake schema has normalized data i.e one dimension table
contains another dimension table like parent table and
child table
we can't get the data from child table directly i.e it
manitains secrecy

Answer / raja sekhar

this can be used when the project data having the more number of devisions along with sub devision in one particular part of department. and more number of duplicated data is used for the project developmen. eg. pharma projects....

Is possible to create skid in dim,fact tables?

0 Answers   NTT Data,

---

Can you explain engine tier in information server?

0 Answers  

---

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  

---

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  

---

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

---

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  

---

What is a range lookup?

2 Answers   IBM,

---

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

how to load meta data

2 Answers   IBM,

---