DataStage Interview Questions and Answers,Solution and Explanation - Part 5
What is the importance of Surrogate Key in Data warehousing?
Ans : Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database
What does a Config File in parallel extender consist of?
Ans: Config file consists of the following. a) Number of Processes or Nodes. b) Actual Disk Storage Location.
How many places you can call Routines?
Ans:Four Places you can call (i) Transform of routine (A) Date Transformation (B) Upstring Transformation (ii) Transform of the Before & After Subroutines(iii) XML transformation(iv)Web base
How did you handle an 'Aborted' sequencer?
Ans: In almost all cases we have to delete the data inserted by this from DB manually and fix the job and then run the job again.
Is it possible to calculate a hash total for an EBCDIC file and have the hash total stored as EBCDIC using Datastage ?
Ans: Currently, the total is converted to ASCII, even tho the individual records are stored as EBCDIC.
Compare and Contrast ODBC and Plug-In stages?
Ans: ODBC :
a) Poor Performance.
b) Can be used for Variety of Databases.
c) Can handle Stored Procedures.
Plug-In: a) Good Performance. b) Database specific.(Only one database)
What is Functionality of Link Partitioner and Link Collector?
Ans: Containers : Usage and Types?
Containers is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project.
Explain Dimension Modelling types along with their significance
Ans: Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling.
Did you Parameterize the job or hard-coded the values in the jobs?
Ans: Always parameterized the job. Either the values are coming from Job Properties or from a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some parameters in your jobs.
How did you connect with DB2 in your last project?
Ans: Most of the times the data was sent to us in the form of flat files. The data is dumped and sent to us. In some cases were we need to connect to DB2 for look-ups as an instance then we used ODBC drive.
What are the often used Stages or stages you worked with in your last project?
Ans: A) Transformer, ORAOCI8/9, ODBC, Link-Partitioner, Link-Collector, Hash, ODBC, Aggregator, Sort.
How many jobs have you created in your last project?
Ans: 100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it need not be the same number for everybody
Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you have taken in doing so?
Ans: Yes. The following are some of the steps; I have taken in doing so:
1) Definitely take a back up of the whole project(s) by exporting the project as a .dsx file.
2) See that you are using the same parent
Readers who viewed this page, also viewed:
- DataStage Interview Questions and Answers,Solution and Explanation - Part 3 (45.5%)
- Web Portal Integration with Siebel Applications (45.5%)
- XML Tools And Utilities (45.5%)
- DataStage Interview Questions and Answers,Solution and Explanation - Part 9 (36.4%)
- DataStage Interview Questions and Answers,Solution and Explanation - Part 2 (36.4%)
- Seven Stages to a Management Role (36.4%)
- Configuring Actuate Siebel Reports Server – Post Installation Tasks (36.4%)
- EIM Tuning to improve performance (36.4%)
- SQL Server Integration Services (36.4%)
- Development Tools used in Open UI development (27.3%)