Answer / rameshreddy

After dimension load takes place we can load the Fact tables.
and

size of data warehouse for small projects 100-500gb
medium projects 500-1000gb
large projects 1000-N gb

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

diffrence between command task and control task

1 Answers   iNautix,

---

how many session run unix environment what command using ?

1 Answers   HCL,

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

what is row level and column level indicator?

1 Answers   TCS,

---