Shivangi

• Dec 3rd, 2013

 

Bottom-up approach

Shivangi Goel

• Dec 12th, 2013

 

Client-sever

mona

• Dec 24th, 2013

 

2- tier architecture, 3- tire architecture or 4- tier architecture

Dileep J

• Jan 29th, 2014

 

There mainly 3 parts . 1. DS Engine 2. Metadata Repository 3. Services.
If these 3 tiers installed on a single server the it will be called Single Tier architecture.
If DSEngine on 1 Server and Metadata Repository and WAS Services on another server then it will be called 2 tier architecture.
If these 3 are on Different servers the it will be 3 tier architecture.
And Dont forget that The DS Client will be installed on Windows Server and connection has to be established from Server to client.

Apart from these... there are SMP(Symmetric Multi Processing(Sharing)) and MPP(Massive Parallel Processing(Share Nothing) environments.

Correct me if I am Wrong...


Cheers... Dileep J.

shiv

• Jun 11th, 2014

 

The above answer, is to architecture of Datastage, its not the architecture of project.
Project architecture would be like:
*****************************
You have: 1 Source--------> 1 Staging Area-------->1 Temporary area to store ur transformed data-------> finally ur target.
So its 4 layer architecture.

rstrainings

• Apr 15th, 2015

 

we can say like there is a staging area to store the data in the form of tables, and then it transforms to ETL stage (Here we will do all the conversions,remove duplicates,joining,merging etc) then dimension load and fact load from that we load to production and then to maintenance

0.different source of inputs
1.staging area
2.ETL Transform stage
3.Dimension and Fact load
4.EDW