rajshankar_s

 Profile Answers by rajshankar_s Questions by rajshankar_s

• Apr 4th, 2006

U can create a UNIX shell script which will pass the parameters to the job and u also can create logs for the whole run process of the job.

nelab28

 Profile Answers by nelab28 Questions by nelab28

• Oct 25th, 2005

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)

Answer Question  Select Best Answer

Sharanu Patil

• Feb 28th, 2006

I think there is option to load DB2 database ,u just drag that & u can use it to load      or It is better to use ODBC .

nelab28

 Profile Answers by nelab28 Questions by nelab28

• Oct 25th, 2005

You need to configure the ODBC connectivity for database (DB2 or AS400) in the datastage.

Answer Question  Select Best Answer

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 23rd, 2009

Deyault buffer size foe seq file is 128MB. if you want increse manually, to to Adminstrator tunable tab--> buffer size option there you can specify if you want increase.regards,Veeru.

Answer Question  Select Best Answer

OCI means orabulk data which used client having bulk data its retrive time is much more ie., your used to orabulk data the divided and retrived

Sharanu Patil

• Feb 28th, 2006

OCI means oracle call interface i.e this acts like native tool to load oracle databaseU can just drag the oracle OCI from options and load

nelab28

 Profile Answers by nelab28 Questions by nelab28

• Oct 25th, 2005

OCI doesn't mean the orabulk data. It actually uses the "Oracle Call Interface" of the oracle to load the data. It is kind of the lowest level of Oracle being used for loading the data.

Answer Question  Select Best Answer

anil_k_nayaka

 Profile Answers by anil_k_nayaka Questions by anil_k_nayaka

• Jan 25th, 2012

UTF 8 is a type of file format to read files in dos format by datastage jobs.
This file may contain characters not only in English but also in foreign language

Answer Question  Select Best Answer

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 18th, 2010

Troubleshooting in datastage server jobs involves monitoring the job log for fatal errors and taking appropriate actions to resolve them.There can be various errors which could be encountered while ru...

Answer Question  Select Best Answer

Speed

• Jan 7th, 2006

Row Merger, Row splitter are only present in parallel Stage .

bvrp

 Profile Answers by bvrp Questions by bvrp

• Dec 19th, 2005

? DataStage Standard Edition was previously called DataStage and DataStage Server Edition. ? DataStage Enterprise Edition was originally called Orchestrate, then renamed to Parallel Extender when purc...

Answer Question  Select Best Answer

Sivarao

• Dec 27th, 2005

Incremental load means daily load.when ever you are selecting data from source, select the records which are loaded or updated between the timestamp of lastsuccessful load and todays load start date a...

Dimple

• Dec 5th, 2005

You can create a table where u can store the last successfull refresh time for each table/Dimension.Then in the source query take the delta of the last successful and sysdate should give you incremental load.

Answer Question  Select Best Answer

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 18th, 2010

There is no such thing like "BibhudataStage Oracle plug-in" in Datastage.The question seems to be wrong.

Answer Question  Select Best Answer

sekr

 Profile Answers by sekr Questions by sekr

• Jan 30th, 2006

Can explain ! each of type where when and how to use.

Satheesh

• Jan 24th, 2006

Hai, These are the three different stages: i) Custom ii) Build iii) Wrapped

Answer Question  Select Best Answer

sekhu_da

• Dec 22nd, 2006

buildopts generates c++ code ( oops concept)subroutine :- is normal programe and u can call any where in your project.

Answer Question  Select Best Answer

shiva

• Jun 29th, 2006

Parallel extender is that the parallel processing of data extraction and transformation application . there are two types of parallel processing 1) pipeline parallelism 2) partition parallelism.

omkar

• Apr 23rd, 2006

its a new version of datastage called PX it process data using partion/collection methods (algorithms) it is very fast compare to older (server) version..partioning can be defined via Config file whic...

Answer Question  Select Best Answer

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 18th, 2010

In datastage , "string" is the datatype of a column.When you create a column,you get "String" as one of the options along with other  datatypes.Also,this option is presen...

Answer Question  Select Best Answer

pavan

• May 13th, 2006

ORABULK is used to load bulk data into single table of target oracle database.BCP is used to load bulk data into a single table for microsoft sql server and sysbase.

ragkris

• Mar 1st, 2006

these are called as pilu-in stages orabulk is used when v have bulk data in oracle then v go for orabulk for other than oracle database v go for bcp stages.if u have any doubts feel free to mail me at letter4raghu@yahoo.co.in

Answer Question  Select Best Answer

RamaPrasad Batchu

• Mar 10th, 2006

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

satheesh_color

 Profile Answers by satheesh_color Questions by satheesh_color

• Mar 9th, 2006

We can handle by using constraints and store it in file or DB.

Answer Question  Select Best Answer

ramoojobs

 Profile Answers by ramoojobs Questions by ramoojobs

• Apr 21st, 2006

U can view all the environment variables in designer. U can check it in Job properties. U can add and access the environment variables from Job properties

srinivas

• Apr 14th, 2006

u can call it in designer windowunder that job propertiesthere u can add an new environment variable r u can use the existing one

Answer Question  Select Best Answer

aranjan

 Profile Answers by aranjan Questions by aranjan

• Apr 5th, 2006

Hi,   I think we can call a job into another job. In fact calling doesn't sound good, because you attach/add the other job through job properties. In fact, you can attach zero or more jobs. ...

Sonal

• Mar 21st, 2006

Hi,We cannot call one job within another in DataStage, however we can write a wrapper to access the jobs in a stated sequence.We can also use sequencer to sequence the series of jobs.

Answer Question  Select Best Answer

glaciya

 Profile Answers by glaciya Questions by glaciya

• Dec 16th, 2011

Please check your language, it may be the language of your computer did not match your servers language.

Answer Question  Select Best Answer

parvathi

• Oct 2nd, 2007

Not clear with question. But you cannot directly link seq.file to other seq.file. you can give the link as?a reject link but no data will carry thru link.

Answer Question  Select Best Answer

rajenmari

 Profile Answers by rajenmari Questions by rajenmari

• Mar 26th, 2007

What type of error dud you got.explain error.

Answer Question  Select Best Answer