nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Nov 29th, 2009

Combinabilty mode means datastage will combine the operators in a single process.If  combinability mode is disabled,the number of Unix processes will increase.  It can be set by setting &quo...

Answer Question  Select Best Answer

When the data processed by job1 is locked by job2 with higher priority, what will happen about the status of job1, changing from running to aborted , or still running. does it have any relationship with the database

vujjini1974

 Profile Answers by vujjini1974 Questions by vujjini1974

• Sep 30th, 2009

If its reference dataset and you are doing Lookup then job will run but no records will come from that Dataset, so you should rerun the dataset job and then run the other job to get the records.

Answer Question  Select Best Answer

What is the purpose of Debugging stages? In real time Where we will use?

rajul.ds

 Profile Answers by rajul.ds Questions by rajul.ds

• Jul 22nd, 2008

Hi the main use of Debugging Stages(row gen,peak,tail,head etc) are they are help full to monitor jobs,and they generate mock data wen we dont have real time data to test

Answer Question  Select Best Answer

How to call a Stored procedure which is in SQL Server database in Datastage job?

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 23rd, 2009

You can use strored procedure stage in DS to call the any stored procedures from any Database type.Regards,Veeru.

Answer Question  Select Best Answer

bhanutej

 Profile Answers by bhanutej Questions by bhanutej

• Jun 26th, 2008

hi,first check in the director's log about the job condition.if you cannot find the errorgo to the input to output datatye conversions.or elsecheck  the configiration file APT_CONFIG_FILE

Answer Question  Select Best Answer

How we import xml files into source stage?

nagakalyan

 Profile Answers by nagakalyan Questions by nagakalyan

• Jun 24th, 2008

In source file we write sql queryselect distinct(sal) from customer_tab where Loc = 'Hyderabad',and rcp should be enable

Answer Question  Select Best Answer

I am new to data stage, so I am a bit confused when to use ODBC and when OCI.Added to it I saw the question where it was asked how to remove duplicate records in the target and many of them answered that you need to use a aggregator to count on the key if its more than 1 it has a duplicate value then you need to remove that but how can a key have duplicate value?

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 19th, 2009

The difference b/w ODBC and OCI is, odbc supports to read or write any kind of relational DB but OCI supports only oracle DB.For suppose if you want read a oracle table in DS in that case if you use odbc it wont give you good performance but oci will give good performance.Regards,Veeru.

Answer Question  Select Best Answer

What for exactly fileset is used?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 10th, 2010

A Fileset can be used to store records(Just like a dataset or sequential file but,the way of storing records is different in filesets,datasets and sequential files.)

Answer Question  Select Best Answer

How we can increase the speed of job in datastage?

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 19th, 2009

To improve DS job performence we can fallow sertain techniques If it is PX job we can use pipeline or data partition techniques to run single job into multiple instance based on server configuration ...

Answer Question  Select Best Answer

Is it like that if we define the values of variables in DSParams file then there is no need to give the values at job level ar Project level ?& how to configure this file at job level ?so that we need not hardcode the values.....

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 19th, 2010

yes.DSParams file contains all the project level parameters which are set up in Datastage Administrator.If the values are provided/modified in this file,the changes are automatically reflected in the ...

Answer Question  Select Best Answer

What are the datastage standards to be considered?

Saibal Samaddar

 Profile Answers by Saibal Samaddar Questions by Saibal Samaddar

• May 4th, 2010

Naming conventions, especially for DataStage Project categories, stage names, and links.

Answer Question  Select Best Answer

What is Orchestrate Schema? Distinguish internal data type (Orchestrate schema) vs external data type

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 25th, 2010

Orchestrate schema defines the fields and their datatypes.There are two types of Orchestarte shcemas a) Input Schems b)Output schema.Orchestrate Schema can be compared with "STRUCT" of C.Example : RollNo - int32

Answer Question  Select Best Answer

I am working on Datastage. Can any body tell me how to work on repeating fields and multiple headers.

bhaskar.jha

 Profile Answers by bhaskar.jha Questions by bhaskar.jha

• Jul 25th, 2008

We should create some staging variable & define the value for repeating fields there & then just map these to respective columns.

Answer Question  Select Best Answer

How low level design will be prepared in datastage?

devraj26e

 Profile Answers by devraj26e Questions by devraj26e

• Feb 5th, 2009

Extraction over view (what is the size of the source file, what is the volume of each file, what?type of file it is), how to map the files from source to target, what kind of business logic we have to implement, how to conduct unit testing all these comes under low level designing.?

Answer Question  Select Best Answer

Rajesh B

• Jun 8th, 2014

Hi The hierarchy is nothing but parent and child relationship....
lets say the country is parent -->state is child to it---> city is child to it--->house no is child to it

here if anyone needs hierarchy you can say from country-->state-->city-->house is the hierarchy relationship

Answer Question  Select Best Answer

pradeep

• Apr 20th, 2012

To the best of my knowledge, By using partitioning technique may be used for performance increases. and to select relevant stage for developing transformation

Answer Question  Select Best Answer

How to clear logs after 5 days, by using a routine?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 25th, 2009

The logs can be cleared by deleting entries from the Universe table RT_LOGn.Here n is the job number.For this you need to go to Datastage Administrator - > Command.Here you can execute the queries on the universe tables.

Answer Question  Select Best Answer

How to extract data from source to staging area using datastage parallel extender?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 18th, 2010

Design your job as per the requirement.If the source is a sequential file,use a sequential file stage.  If the source is a table, use database stages like OCI,DRS,ODBC etc...Use a transformer to ...

Answer Question  Select Best Answer

Expalin difference between Data Sets and File Sets? where each one is used and how they are used?What is the size limit?

Abhijain

 Profile Answers by Abhijain Questions by Abhijain

• Sep 19th, 2008

The dataset and fileset both are file stage. Dataset can have single input link or single output link whereas, Fileset can have single input link or single output link and a single reject link.File se...

Answer Question  Select Best Answer

How to pass input parameters using UNIX Shell script to DataStage Director?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Dec 29th, 2009

From UNIX, Parameters are passed to datastage job while running them.This can be done by passing "-param" paramater to dsjob command.Syntax :dsjob -run mode Normal -param param1=value1 project name jobname

Answer Question  Select Best Answer