Warehouse DataStage Questions And Answers

21⟩ Explain Containers Usage and Types?

Container 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. ?

There are two types of shared container:?

1.Server shared container. Used in server jobs (can also be used in parallel jobs).?

2.Parallel shared container. Used in parallel jobs. You can also include server shared containers in parallel jobs as a way of incorporating server job functionality into a parallel stage (for example, you could use one to make a server plug-in stage available to a parallel job).regardsjagan

Is this answer helpful? 0 Yes | 0 No

Answer This Question

148 views

22⟩ Explain What is the flow of loading data into fact & dimensional tables?

Here is the sequence of loading a datawarehouse.

1. The source data is first loading into the staging area, where data cleansing takes place.

2. The data from staging area is then loaded into dimensions/lookups.

3.Finally the Fact tables are loaded from the corresponding source tables from the staging area.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

135 views

23⟩ How to pass parameters to job by using file?

You can do this, by passing parameters from unix file, and then calling the execution of a datastage job. the ds job has the parameters defined (which are passed by unix)

Is this answer helpful? 0 Yes | 0 No

Answer This Question

148 views

24⟩ What is DS Director used for - did u use it?

Datastage Director is GUI to monitor, run, validate & schedule datastage server jobs.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

134 views

25⟩ Explain How many jobs have you created in your last project?

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

Is this answer helpful? 0 Yes | 0 No

Answer This Question

125 views

26⟩ list out the versions of datastage Parallel , server editions and in which year they are realised?

Please do fish for such kind of info from the net.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

165 views

27⟩ How good are you with your PL/SQL please explain?

You will not be writtinf pl/sql in datastage ! sql knowledge is enough ...

Is this answer helpful? 0 Yes | 0 No

Answer This Question

135 views

28⟩ What is DS Administrator used for - did u use it?

The Administrator enables you to set up DataStage users, control the purging of the Repository, and, if National Language Support (NLS) is enabled, install and manage maps and locales

Is this answer helpful? 0 Yes | 0 No

Answer This Question

139 views

29⟩ It is possible to access the same job two users at a time in datastage?

No it is not possible for the same job to be accessed by two users, because if one of the job is being used by one user then if the second one tries to open the same job then you get the error as "Job (jobname) is being accessed by another user"

Is this answer helpful? 0 Yes | 0 No

Answer This Question

138 views

30⟩ How to eliminate duplicate rows?

The Duplicates can be eliminated by loading thecorresponding data in the Hash file. Specify the columns on which u want to eliminate as the keys of hash.

you can delete duplicate records from source itself using datastage taking option as userdefined query, instead of taking table read option. and u can use remove duplicate stage in datastage. and using of hashfile as source also based on the hash key.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

143 views

31⟩ What is a project? Specify its various components?

You always enter DataStage through a DataStage project. When you start a DataStage client you are prompted to connect to a project. Each project contains:

DataStage jobs.

Built-in components. These are predefined components used in a job.

User-defined components. These are customized components created using the DataStage Manager or DataStage Designer

You always enter DataStage through a DataStage project. When you start a DataStage client you are prompted to connect to a project. Each project contains:

Is this answer helpful? 0 Yes | 0 No

Answer This Question

145 views

32⟩ What is differences between Oracle8i/9i?

Mutliproceesing,databases more dimesnionsal modeling

Is this answer helpful? 0 Yes | 0 No

Answer This Question

139 views

33⟩ Explain Dimensional modelling is again sub divided into 2 types?

a) Star Schema - Simple & Much Faster. Denormalized form.

b) Snowflake Schema - Complex with more Granularity. More normalized form.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

147 views

34⟩ Explain What is job control?how it is developed?explain with steps?

Controlling Datstage jobs through some other Datastage jobs. Ex: Consider two Jobs XXX and YYY. The Job YYY can be executed from Job XXX by using Datastage macros in Routines.

To Execute one job from other job, following steps needs to be followed in Routines.

1. Attach job using DSAttachjob function.

2. Run the other job using DSRunjob function

3. Stop the job using DSStopJob function

Is this answer helpful? 0 Yes | 0 No

Answer This Question

139 views

35⟩ Explain How to handle the rejected rows in datastage?

We can handle rejected rows in two ways with help of Constraints in a Tansformer.1) By Putting on the Rejected cell where we will be writing our constarints in the properties of the Transformer2)Use REJECTED in the expression editor of the ConstraintCreate a hash file as a temporory storage for rejected rows. Create a link and use it as one of the output of the transformer. Apply either ofthe two stpes above said on that Link. All the rows which are rejected by all the constraints will go to the Hash File.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

178 views

36⟩ Explain What does a Config File in parallel extender consist of?

Config file consists of the following.

a) Number of Processes or Nodes.

b) Actual Disk Storage Location.

The APT_Configuration file is having the information of resource disk,node pool,and scratch information,

node information in the since it contains the how many nodes we given to run the jobs, because based on the nodes only data stage will create processors at back end while running the jobs,resource disk means this is the place where exactly jobs will be loading,scratch information will be useful whenever we using the lookups in the jobs

Is this answer helpful? 0 Yes | 0 No

Answer This Question

139 views

37⟩ Explain How to implement type2 slowly changing dimenstion in datastage?

Slow changing dimension is a common problem in Dataware housing. For example: There exists a customer called lisa in a company ABC and she lives in New York. Later she she moved to Florida. The company must modify her address now. In general 3 ways to solve this problem

Type 1: The new record replaces the original record, no trace of the old record at all, Type 2: A new record is added into the customer dimension table. Therefore, the customer is treated essentially as two different people. Type 3: The original record is modified to reflect the changes.

In Type1 the new one will over write the existing one that means no history is maintained, History of the person where she stayed last is lost, simple to use.

In Type2 New record is added, therefore both the original and the new record Will be present, the new record will get its own primary key, Advantage of using this type2 is, Historical information is maintained But size of the dimension table grows, storage and performance can become a concern.

Type2 should only be used if it is necessary for the data warehouse to track the historical changes.

In Type3 there will be 2 columns one to indicate the original value and the other to indicate the current value. example a new column will be added which shows the original address as New york and the current address as Florida. Helps in keeping some part of the history and table size is not increased. But one problem is when the customer moves from Florida to Texas the new york information is lost. so Type 3 should only be used if the changes will only occur for a finite number of time.

Is this answer helpful? 0 Yes | 0 No

Answer This Question

130 views

Warehouse DataStage

Home Data Warehouse Warehouse DataStage

37 Warehouse DataStage Questions And Answers

21⟩ Explain Containers Usage and Types?

22⟩ Explain What is the flow of loading data into fact & dimensional tables?

23⟩ How to pass parameters to job by using file?

24⟩ What is DS Director used for - did u use it?

25⟩ Explain How many jobs have you created in your last project?

26⟩ list out the versions of datastage Parallel , server editions and in which year they are realised?

27⟩ How good are you with your PL/SQL please explain?

28⟩ What is DS Administrator used for - did u use it?

29⟩ It is possible to access the same job two users at a time in datastage?

30⟩ How to eliminate duplicate rows?

31⟩ What is a project? Specify its various components?

32⟩ What is differences between Oracle8i/9i?

33⟩ Explain Dimensional modelling is again sub divided into 2 types?

34⟩ Explain What is job control?how it is developed?explain with steps?

35⟩ Explain How to handle the rejected rows in datastage?

36⟩ Explain What does a Config File in parallel extender consist of?

37⟩ Explain How to implement type2 slowly changing dimenstion in datastage?

Quick Links:

Warehouse DataStage

Home Data Warehouse Warehouse DataStage

37 Warehouse DataStage Questions And Answers

21⟩ Explain Containers Usage and Types?

22⟩ Explain What is the flow of loading data into fact & dimensional tables?

23⟩ How to pass parameters to job by using file?

24⟩ What is DS Director used for - did u use it?

25⟩ Explain How many jobs have you created in your last project?

26⟩ list out the versions of datastage Parallel , server editions and in which year they are realised?

27⟩ How good are you with your PL/SQL please explain?

28⟩ What is DS Administrator used for - did u use it?

29⟩ It is possible to access the same job two users at a time in datastage?

30⟩ How to eliminate duplicate rows?

31⟩ What is a project? Specify its various components?

32⟩ What is differences between Oracle8i/9i?

33⟩ Explain Dimensional modelling is again sub divided into 2 types?

34⟩ Explain What is job control?how it is developed?explain with steps?

35⟩ Explain How to handle the rejected rows in datastage?

36⟩ Explain What does a Config File in parallel extender consist of?

37⟩ Explain How to implement type2 slowly changing dimenstion in datastage?

BE THE FIRST TO KNOW

Quick Links: