Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 8451 Views
- IBM, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / balaji
I think they asked about architecture.
there are two types of Architecture
1. SMP ( symmetrically multi Processig )
2. MPP ( Massively Parallel processin )
| Is This Answer Correct ? | 1 Yes | 0 No |
how many steps are there in etl process?
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
What is the main difference between peek stage and copy stage
What is Data Vault???
Mention few test cases and explain them?
What is fact? What are the types of facts?
where are the log files generally stored.Can you change the path of the file.what can the path be?
what is pmrep command?
What is data cleaning?
how to connect to a flatfile through ftp in informatica
if u can't find what you are looking for in lookup table, how do you handle?
what is the difference between OLTP database and data warehousing database?
Teradata 
