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

How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?

1 Answers   IBM,

---

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

Differentiate between datastage and informatica?

0 Answers  

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

0 Answers   Syntel,

---

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers   Wipro,

---

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

---

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,

---

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

---