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
- 8364 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 |
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
Can there be sub steps of etl steps?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what are the production issues in datastage?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What are the different Lookup methods used in Informatica?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you
when should one create lookup transformation ?
what are the types in error loging?
Teradata 
