DataStage - 1.What about System variables? 2.How can we create Containers? 3.How can we improve the performance

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 152 of 390

1.What about System variables?
2.How can we create Containers?
3.How can we improve the performance of DataStage?
4.what are the Job parameters?
5.what is the difference between routine and transform and function?
6.What are all the third party tools used in DataStage?
7.How can we implement Lookup in DataStage Server jobs?
8.How can we implement Slowly Changing Dimensions in DataStage?.
9.How can we join one Oracle source and Sequential file?.
10.What is iconv and oconv functions?
11.Difference between Hashfile and Sequential File?
12. Maximum how many characters we can give for a Job name in DataStage?

Total Answers and Comments: 5

Last Update: July 31, 2007 Asked by: sdfsdf

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 21, 2006 07:25:50

satheesh_color

Member Since: March 2006 Contribution: 8

RE: 1.What about System variables? 2.How can we ...

Answers for ur Question in simple words:2.Containers are nothing but the set of stages with links3.Trun in-process buffer and transaction size4.Nothing but parameters to pass in runtime5.6.Lots of there7.using hashed File8.CDC Stage9.10.Powerful function for Date transformation11.Access speed is slow in sequential file rather than hashed File12.If you know just tell me

Is this answer useful? Yes | No

March 29, 2006 17:56:38

Purnima

RE: 1.What about System variables? 2.How can we ...

System variables comprise of a set of variables which are used to get system information and they can be accessed from a transformer or a routine. They are read only and start with an @.

Is this answer useful? Yes | No

March 29, 2006 18:12:19

Purnima

RE: How can we improve the performance in DataStage ?

In server canvas we can improve performance in 2 ways :

Firstly we can increase the memory by enabling interprocess row buffering in job properties and

Secondly by inserting an IPC stage we break a process into 2 processes.We can use this stage to connect two passive stages or 2 active stages.

Is this answer useful? Yes | No

December 13, 2006 12:13:10

Shiva

12. Maximum how many characters we can give for a Job name in DataStage?

The following rules apply to the names that you can give DataStage jobs:

Job names can be any length.

They must begin with an alphabetic character.

They can contain alphanumeric characters and underscores.

Job category names can be any length and consist of any characters

including spaces

Is this answer useful? Yes | No

July 31, 2007 06:06:48

Fahmida

RE: 1.What about System variables? 2.How can we ...

1.System Variables are inbuilt functions that can be called in a transformer stage
2.Containers is a group of stages and links thy are of 2 types local containers and shared containers
3.Using IPC Managing the array and transaction size Project tunables can be set through the Administrator.
4.Values that would be required during the job run
5.Routines are which call the jobs or any actions to be performed using DS Transforms are the manipulation of data during teh load.
6.
7.Using HASH FILE
8. Using the target oracle stages depending on teh update action
9.using a row id or seq generated numbers
10.DATE FUNCTIONS
11.Sequential file reads data sequentially using hash file the read process is faster
12.it can be any length

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank