Answer / avinash(datastage proff)

looking for answer

Answer / madhu tallapaneni

For example: dB every branch have each mgr

Manager
Reliance comm.

Reliance Group : manager Top Level mgr(TLM)
Reliance power details of below
sales
Manager customer
Reliance Fresh TLM needs employee
period
` order
Input

Explanation of above example: Reliance group with some there branches and every branch have one manager. And for all this manager one Top level manager (TLM) will be there. And TLM needs the details of list shown above for analyze.
Bottom level
For above example how ETL process is done shown below RC-mgr
reliance fresh ERP
mini WH/ Data mart DWH independent Data Mart Dependent Data Mart Reliance Fresh(taking one from group directly)

Dependent Data Mart: means the ETL process takes all manager information or dB and keep in the Warehouse. By that the data transmission between warehouse and data mart where depends upon by each other. Here Data mart is also called as ‘Bottom level’/ ‘mini WH’ as shown in blue color in above figure i.e., the data of individual manager (like RF, RC, RP and so on). Hence the data mart depends up on the WH is called dependent data mart.

Independent Data Mart: only one or individual manager i.e., data mart were directly access the ETL process with out any help of Warehouse. That’s why its called independent data mart.

6.1 Two level approaches:
For the both approaches two layers architecture will apply.
1. Top-Bottom level approach, and
2. Bottom- Top level approach.

6.1. Top – Bottom level approach:
The level start from top means as per example Reliance group to their individual managers their ETL process from their to Data Warehouse (top level) and from their to all separate data marts (bottom level).
R Comm. Data Mart


R Power Data Mart
Reliance Group
Warehouse
R Fresh Data Mart

Top level Bottom level

Layer I Layer II

Top – Bottom level approach
In the above the top – bottom level is defined, and this approach is invented by W. H. Inner.
Here, warehouse is top level and all data mart are bottom level as shown in the above figure.

6.2. Bottom – top level approach:
Means from here the ETL process takes directly from data mart (DM) and the data put in the warehouse for reference purpose or storing the DM in the Data WareHouse (DWH).



R comm.
DM
R power
DM DWH
Reliance Group
R fresh DM

Layer I Layer II Bottom level Top level

What are the types of views in datastage director?

0 Answers  

---

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

---

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,

---

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

---

wt is the difference between swith and filter stage

6 Answers   IBM,

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

---

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

3 Answers   Reliance,

---

Does datastage support slowly changing dimensions ?

0 Answers  

---

how to load meta data

2 Answers   IBM,

---