Answer / guru avula

1.In a project source systems are differnet and also all
source systems are not availble in same time.for eg 1
source is availble at 1AM and 2n one at 2 AM etc
But our schedule jobs run at different time ,so we have to
pick the data from source system based on source availble
time and put into staging area.
2.All source systems table formats and column formats are
diffrent ,so we have to sync all .
For above two reasons we go for staging area

Answer / srinivas

I will add some points to first answer

Source system send the raw data what ever data they have simply they will send to us.

In staging we do the cleansing, remove-duplicate and null handling process and load the data into staging tables.

Then we applying business logic's and loading into dim and fact tables.

What is "fatal error/rdbms code 3996" error?

0 Answers  

---

Could anyone give brief explanation bout datastage admin

0 Answers  

---

what is A Datastage?

2 Answers  

---

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,

---

Describe the main features of datastage?

0 Answers  

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

How many areas for files does datastage have?

0 Answers  

---

what is .dsx files

3 Answers   IBM,

---

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

---

Why we need datasets ratherthan sequential files?

5 Answers  

---

What is a quality stage?

1 Answers  

---