sai3689

• Aug 24th, 2015

But how to create batch file Runbatchjobs.bat? Can you explain with steps

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 17th, 2010

From command prompt batches can be created in following way :a) create a batch file say RunbatchJobs.batb) Open this file in notepad.c) Now,write the command "dsjob" with proper syntax for e...

Answer Question  Select Best Answer

Batch programe is the programe it's generate run time to maintain by the datastage it self but u can easy to change own the basis of your requirement (Extraction, Transformation,Loading) .Batch programe are generate depands your job nature either simple job or sequencer job,You can see this programe on job controll option.

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 17th, 2010

A Batch Program is used to run a batch of jobs by writing the Server routine code in the job control section.To generate a batch program,do following:a) Open datastage director.b) Go to Tools->Batch->...

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 17th, 2010

A Batch Program is used to run a batch of jobs by writing the Server routine code in the job control section.To generate a batch program,do following:a) Open datasatge director.b) Go to Tools->Batc...

Answer Question  Select Best Answer

qwert123

 Profile Answers by qwert123 Questions by qwert123

• Jun 30th, 2009

VERSION CONTROL In addition, DataStage offers version control that saves the history of all the data integration development. It preserves application components such as table definitions, transformat...

vick

• Oct 30th, 2005

Version Controlstores different versions of DS jobsruns different versions of same jobreverts to previos version of a jobview version histories

Answer Question  Select Best Answer

vasanthsolai

 Profile Answers by vasanthsolai Questions by vasanthsolai

• Apr 17th, 2008

NLS=NATIONAL LANGUAGE SUPPORT,it is used to sort the data,and give the data to users to local formatt.....

Aravind

• Dec 23rd, 2005

By using NLS function we can do the following          - Process the data in a wide range of languages         ...

Answer Question  Select Best Answer

Pl send material for data stage

ajaygosh

 Profile Answers by ajaygosh Questions by ajaygosh

• Dec 8th, 2007

Here is a good link by Joshy George on this. DataStage Parallel routines made really easyhttp://blogs.ittoolbox.com/dw/soa/archives/datastage-parallel-routines-made-really-easy-20926

sivarao

 Profile Answers by sivarao Questions by sivarao

• Dec 28th, 2005

there are 3 kind of routines is there in Datastage.1.server routines which will used in server jobs.    these routines will write in BASIC Language2.parlell routines which will used in ...

Answer Question  Select Best Answer

BethWilson

 Profile Answers by BethWilson Questions by BethWilson

• Nov 5th, 2010

Interesting comparison. From my experience, and if those numbers are accurate, then there might be a?few other reasons:1. You replaced the worst DataStage developers in the world with reasonable Infor...

handlider

 Profile Answers by handlider Questions by handlider

• Oct 14th, 2009

You are much better off using SSIS from Microsoft SQL Server (2005 & 2008)RegardsJP

Answer Question  Select Best Answer

vijaypatiln

 Profile Answers by vijaypatiln Questions by vijaypatiln

• Jul 28th, 2009

In process allows connected active stages to pass data via buffers, rather than row by row.

Inter process enables the job to run using a separate process for each active stage, which will run simultaneously on a separate processor.

Daniel

• May 14th, 2006

In-processYou can improve the performance of most DataStage jobs by turning in-process row buffering on and recompiling the job. This allows connected active stages to pass data via buffers rather tha...

Answer Question  Select Best Answer

priya06ind

 Profile Answers by priya06ind Questions by priya06ind

• Nov 3rd, 2009

Default is 128 MB and max is 999 MB, Min is 0 MB.

Alfons

 Profile Answers by Alfons Questions by Alfons

• May 5th, 2006

Hello,Take a look at the uvconfig file:# 64BIT_FILES - This sets the default mode used to#   create static hashed and dynamic files.#   A value of 0 results in the creation of 32-b...

Answer Question  Select Best Answer

Itishree

• Dec 2nd, 2013

You can use either of the below options: Seq File->Sort->Remove Duplicate ->O/P in Remove duplicate stage, choose the key column and duplicate to retain last properties Seq File->Remove Duplicate ->O/...

Murat Nur

• Dec 28th, 2006

Hi,if ranking means that belowprop_id  rank1         11         21        32&nbs...

Answer Question  Select Best Answer

Bharath narahari

• Dec 5th, 2006

The flat files will be stored in the unix box ,if u  r environment is Unix,U need to specify the path in the properties of the sequential file stage.... u can parameterise the path

dharma

• Sep 21st, 2006

Normally flat file will be stored at FTP servers or local folders and more over .CSV , .EXL and .TXT file formats available for Flat files.

Answer Question  Select Best Answer

Vidhya

• Dec 21st, 2015

You can call the parallel routine in a parallel job using dsRoutine Function. To call the Server Routine in Parallel job use BASIC_Transformer stage. This stage usually wont present in the design pale...

kmalla

 Profile Answers by kmalla Questions by kmalla

• Jun 29th, 2006

In transformer stage we have to edit the field and click dsRoutines.It will prompt to select the routine .Thats it

Answer Question  Select Best Answer

prassy

• Feb 5th, 2007

U can Parameterize using #parameter-name#... and define the parameter in the job properties..

shiva

• Jun 29th, 2006

#FILENAME#

Answer Question  Select Best Answer

Bharath narahari

• Dec 5th, 2006

U can also do it by using data stage director clean up resources

Jasorn

• Aug 25th, 2006

You should use kill -14 so the job ends nicely. Sometimes use -9 leaves things in a bad state.

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Feb 12th, 2008

Environmental variables are also called as Global variables. There are two types variables are there.1. Local Variables2.Environmental variables/Global VariablesLocal:- only for perticular job onlyEnv...

sekhar.sanaka

 Profile Answers by sekhar.sanaka Questions by sekhar.sanaka

• Feb 3rd, 2008

Basically Environment variable is predefined variable those we can use while creating DS job.we create/declare these variables in DS Administrator.while designing the job we set the properties for the...

Answer Question  Select Best Answer

vasanthsolai

 Profile Answers by vasanthsolai Questions by vasanthsolai

• Apr 14th, 2008

Routines are used to return the values ,transform cannot return the values

JOHN DANIEL

• Nov 8th, 2006

Transformar transform the data from one from to another form .where as Routines describes the business logic.

Answer Question  Select Best Answer

c2

• Sep 5th, 2006

You can do it at any stage.Just do a hash partion of the input data and check the options Sort and Unique.This will do.

Tasneem

• Aug 11th, 2006

Using a sort stage,set property: ALLOW DUPLICATES :false

Answer Question  Select Best Answer

sunayan

 Profile Answers by sunayan Questions by sunayan

• Dec 13th, 2007

A job can be made read only by the follwing process:Export the job in the .dsx format and change the attribute which store the readonly information from 0 ( 0 refers to editable job) to 1 ( 1 refer to...

Gnaneshwar

• Nov 21st, 2007

By creating Protected Project. In Protected Project all jobs are read only. You cant modify the job. If you modify that job it will not effect the job.

Answer Question  Select Best Answer

ajinkyac

 Profile Answers by ajinkyac Questions by ajinkyac

• Jun 16th, 2007

1. if u need to capture mismatches between the two sources, lookups provide easy option

bhaskar jha

• May 16th, 2007

If the volume of data is high then we should use Join stage instead of Lookup.

Answer Question  Select Best Answer

SudhirKanojia

 Profile Answers by SudhirKanojia Questions by SudhirKanojia

• Feb 8th, 2010

This can be achieve by sort & external filter satge.First sort the data in descending order after that use external filter stage & give UNIX command  head -3 in the box.

Sathish123

 Profile Answers by Sathish123 Questions by Sathish123

• Feb 20th, 2007

First sort the data on Marks  column using sort stage then use transformer stage.In constraints use system variable @INROWNUM (@INROWNUM<=3).In this way you can get top 3 marks.

Answer Question  Select Best Answer

Saumendra_int

 Profile Answers by Saumendra_int Questions by Saumendra_int

• Sep 16th, 2008

Hi,You need to know your computer name by right clicking on the computer icon on the desktop and then select properties. After that you will see small window, then you need to select "computer na...

imrankhateeb

• Sep 6th, 2006

The problem is that you have no password for compurter user. better create a password for user.try once

Answer Question  Select Best Answer