what is architecture of your datastage project???
i came across this question many times in interviews in specific what can i answer
plz help me.
Answer Posted / pavan kumar
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 maintainance
0.different source of inputs
1.staging area
2.ETL Transform stage
3.Dimension and Fact load
4.EDW
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
how would u estimate the size of Lookup transform data and index cache?
How many types of transformations supported by sorted input?
how do u really know that paging to disk is happening while u are using a lookup transform?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Which transformation we use to convert 'NA' to 'Not Available'
What is a mapping, session, worklet, workflow, mapplet?
What are the names of the layers in etl?
What are the ETL Testing Operations?
What is meant by incremental load?
What are the types of Data Warehouse applications?
what is session partitioning?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Compare ETL & Manual development?
Can there be sub steps of etl steps?
What are the steps involved in etl process?