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?

Questions by sdfsdf   answers by sdfsdf

Showing Answers 1 - 5 of 5 Answers

satheesh_color

  • Mar 21st, 2006
 

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

  Was this answer useful?  Yes

Purnima

  • Mar 29th, 2006
 

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 @.

  Was this answer useful?  Yes

Purnima

  • Mar 29th, 2006
 

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.

  Was this answer useful?  Yes

Shiva

  • Dec 13th, 2006
 

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

  Was this answer useful?  Yes

Fahmida

  • Jul 31st, 2007
 

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions