Answer / kiran

1)totally how many jobs created in ur project?
Ans:Depend upon duration: suppose u mentioned as like 12-15
months:52 jobs
2)what is ur datamart size & Dwh size
Ans: no one know about size of the DWH but u can define as
like it should be tera bites and datamart size is 6 gb
3)How secure ur project
Ans:take care under Admin
4)could u plz tell be about testing process after complete
the job will run sucessfully or not in Datastage

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

how do u capture duplicates through sort & transformer

4 Answers  

---

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  

---

What is Cleanup Resources and when do you use it?

2 Answers  

---

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---

---

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

What is container and then types?

1 Answers  

---

Which warehouse using in your datawarehouse

0 Answers   IBM,

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---

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

1 Answers  

---

whom do you report?

0 Answers   NTT Data,

---