Search found 27 matches

by femil
Tue May 24, 2011 12:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to check volume of data process
Replies: 0
Views: 1023

How to check volume of data process

Hi everyone,

Could anyone tell me how to check the following in datastage 8.1

1. check volume of data process happens out in the ETL server, including look ups and reference details
2. check Parameters setting that has been done at IIS


Thanks & Regards,
Femil Antony
by femil
Mon Jan 04, 2010 11:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: transform as source
Replies: 1
Views: 1724

transform as source

hi friends can someone tell me how can i use a transform as source stage.. i need to assign some constant values in transform stage without using a source(passive) stage and insert those values into the database using a oracle target stage my purpose is implement this without using any source passiv...
by femil
Tue Dec 29, 2009 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Verb "DSJOB" is not in your VOC.
Replies: 4
Views: 5273

even i tried that but no use and it shows same error
by femil
Tue Dec 29, 2009 3:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Verb "DSJOB" is not in your VOC.
Replies: 4
Views: 5273

Verb "DSJOB" is not in your VOC.

Can any one help me to overcome the error ' Verb "DSJOB" is not in your VOC' getting while executing the DS commands .

ex: dsjob -run Check(Check is a Job) in administrator client
by femil
Mon Dec 21, 2009 11:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: BASIC routines
Replies: 3
Views: 2014

BASIC routines

Hello friends can anyone refer me some site or material to learn routines and its syntax
by femil
Sat Nov 28, 2009 12:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: date function
Replies: 4
Views: 2318

thank you

thank you and which gives the better performance field or conv function
by femil
Sat Nov 28, 2009 11:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: date function
Replies: 4
Views: 2318

date function

what function is used to get the current date format of 'DD-MON-YY' in datastage transformer
by femil
Fri Nov 20, 2009 12:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: project scenario in data stage
Replies: 1
Views: 1309

project scenario in data stage

hi can any one suggest me a project scenario which will use almost all the stages in server job of data stage...

please also refer some sites which provides project scenarios using etl tools..
by femil
Fri Nov 20, 2009 12:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: project scenario in data stage
Replies: 2
Views: 5579

project scenario in data stage

hi can any one suggest me a project scenario which will use almost all the stages in server job of data stage...

please also refer some sites which provides project scenarios using etl tools..
by femil
Fri Nov 13, 2009 11:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ROUTINE
Replies: 4
Views: 2182

i want to pass the records in a file as a parameter to a job
by femil
Fri Nov 13, 2009 4:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ROUTINE
Replies: 4
Views: 2182

ROUTINE

How to read a file record in data stage ROUTINE ?
by femil
Wed Nov 11, 2009 12:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: surrogate key
Replies: 4
Views: 2535

surrogate key

how can i create a surrogate key in data stage for a target table in which records are inserted by two passive stages
by femil
Sat Nov 07, 2009 11:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence no column in transform stage
Replies: 4
Views: 1820

thank you craig...
by femil
Sat Nov 07, 2009 10:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence no column in transform stage
Replies: 4
Views: 1820

can i simply type @IN/OUTROWNUM in the value field of the output column

of transform stage?
by femil
Sat Nov 07, 2009 10:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence no column in transform stage
Replies: 4
Views: 1820

Sequence no column in transform stage

how to create a sequence value for a column in transform stage?