qwert123

 Profile Answers by qwert123 Questions by qwert123

• Jun 29th, 2009

Partition the table if there is huge data. This will enhance performance statistics.

satya

• Jul 18th, 2007

You can right click on the server job and select the "view performance statistics" option. This will show the output in the number of rows per second format when the job runs.Regards.Satish.

Answer Question  Select Best Answer

As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size.

klsrao

 Profile Answers by klsrao Questions by klsrao

• Jun 12th, 2007

Good explanation.

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 8th, 2007

Dynamic Hash Files can automatically adjust their sie - modulous (no. of groups) and separation (group size) based on the incoming data. Type 30 are dynamic. Static files do not adjust their modulous ...

Answer Question  Select Best Answer

Gnaneshwar

• Apr 9th, 2007

Oracle 8i does not support pseudo column sysdate but 9i supportsOracle 8i we can create 256 columns in a table but in 9i we can upto 1000 columns(fields)

Venkat

• Oct 3rd, 2005

Ramanam.v Wrote: mutliproceesing,databases more dimesnionsal modeling

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Feb 12th, 2008

1. Hashfile can be used as lookup but not the seq file.2. Hashfile works based on Hashed algorithm.3. The performence is more in Hashfile when it is used as a ref link(for lkp)4. we can eliminate dupl...

Sanj333

• Aug 30th, 2007

Hash file can be stored in DS memory (Buffer) but Sequential file cannot be.. duplicates will be removed in hashfile i.e, No duplicates in Hashfile.

Answer Question  Select Best Answer

AjaysKumar

 Profile Answers by AjaysKumar Questions by AjaysKumar

• Jun 4th, 2008

Then you have to manually enter all the column description in each stage.RCP- Runtime column propagation

Venkata Maruthi

• Nov 10th, 2005

Runtime column propagation (RCP): If RCP is enabled for any job, and specifically for those stage whose output connects to the shared container input, then meta data will be propagated at run time, so...

Answer Question  Select Best Answer

?

sekr

 Profile Answers by sekr Questions by sekr

• Apr 14th, 2006

if  ur system is mainfarmes then u can utility called load and unload ..load will load the records into main farme systme from there u hv to export in to your system ( windows)

Sharanu Patil

• Feb 28th, 2006

U can use DB2 stage to implement this

Answer Question  Select Best Answer

mahesh

• Aug 4th, 2011

With NLS enabled, datastage can process data in a wide range of languages & accept data in any character set.

Anwar

• Nov 1st, 2006

NLS is basically Local language setting(characterset) .Once u install the DS u wil get NLS present.Just login into Admin and u can set the NLS of your project based on your project requirement.Just ne...

Answer Question  Select Best Answer

Merge is nothing but a filter conditions that have been used for filter condition

shameerok

• Mar 22nd, 2006

Merge stage is a processing stage, it can have any no of input link and only one output link. It is having master data set and one or more data sets. The out put of the Merge stage is master dataset p...

Sharanu Patil

• Feb 28th, 2006

Merge is maily used to join two flat or sequential files in server jobs

Answer Question  Select Best Answer

machaiyer

• Jul 24th, 2006

open the ODBC Data Source Administrator found in the controlpanel/administrative tools.under the system DSN tab, add the Driver to Microsoft Excel.Then u'll be able to access the XLS file from Datastage.

sivarao

 Profile Answers by sivarao Questions by sivarao

• Dec 28th, 2005

Create a DSN in control panel using microsoft excel drivers.uthen u can read the excel file from ODBC stage.

Answer Question  Select Best Answer

arun

• May 30th, 2006

  if the job have good logic that is called as complex job.simply we can say Scenarios .so If you have faced any complexity while creating job please share with us.  

RamaPrasad Batchu

• Mar 10th, 2006

Complex design means having more joins and more look ups. Then that job design will be called as complex job.We can easily implement any complex design in DataStage by following simple tips in terms o...

Answer Question  Select Best Answer

radha_sreddy

 Profile Answers by radha_sreddy Questions by radha_sreddy

• Sep 13th, 2010

1) Primary Link2) Reference Llink3) Reject Link or Breaking Link

pavan

• Aug 31st, 2006

Two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------>

Answer Question  Select Best Answer

sachin

• Nov 21st, 2006

999 MB for reading data into file.999 MB for writing data into file.Thats Approx.2GB for whole Hash File.

BVNREDDY

 Profile Answers by BVNREDDY Questions by BVNREDDY

• Jul 27th, 2006

Max 2 GB for Static hash filenot sure for dynamic

Answer Question  Select Best Answer

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Oct 1st, 2009

Natural key is nothing but primary key, it uses to identify a record uniquly.Surrogate key is to identify a entity uniquly.Regards,Veeru.

sekhu_da

 Profile Answers by sekhu_da Questions by sekhu_da

• Nov 14th, 2006

natural key :- seq no system assigned ..skey :- user assigend ! u can start with any number like 100,10001,2002..

Answer Question  Select Best Answer

Bharath narahari

• Dec 5th, 2006

U can also use the sparse look up property when u have large data in the look up table .....

sreenivas

• Jul 31st, 2006

hi,I Have Datastage s/w from this I can work on some job's ...and not on parallel job's............. if i want to work on this, I? need Enterprise Edition S/w or I can implement lookup stage?in serv...

Answer Question  Select Best Answer

Bharath narahari

• Dec 5th, 2006

No chance ..... u have to kill the job process

sankar

• Aug 28th, 2006

hi,It is possible.Before that u have to kill that job in Datastage Director.Using "Clean up resource" option.With regards,Sankara rao.N

Answer Question  Select Best Answer

Bharath narahari

• Dec 5th, 2006

U can also use Data stage Administrator.Just click on the project and execute command ,just follow the menu joice to get the job name and PID .then kill the process in the unix ,but for this u will require the user name of the datastage in which the process is locked

jgreve

 Profile Answers by jgreve Questions by jgreve

• Oct 4th, 2006

Depending on your environment, you may have lots of process id's.From one of the datastage docs:you can try this on any given node: $ ps -ef | grep dsuserwhere dsuser is the account for datastage.I...

Answer Question  Select Best Answer

madhavsandireddi

 Profile Answers by madhavsandireddi Questions by madhavsandireddi

• Feb 24th, 2011

The major difference between LKP stage, Join stage, merge stage are LKP & JOIN: If the reference data in the LKP stage is huge when compared to the primary data. there is no reject requiremen...

Pavan Batchu

• Nov 12th, 2007

Lookup stage: 1.Can only return multiple matching rows from one reference.2. Can reject rows based on constraint.3. Can set failure.4. Does not need partitioned and sorted input. Merge stage: 1. Can...

Answer Question  Select Best Answer

mcrao1

 Profile Answers by mcrao1 Questions by mcrao1

• Jun 4th, 2012

DataStage Job run from Unix Command Line I am running DataStage Job from Unix Command Line with job level parameters the job is getting abort , can someone correct if there is any syntax problem in t...

Pavan

• Aug 29th, 2005

We can call Datastage Batch Job from Command prompt using 'dsjob'. We can also pass all the parameters from command prompt. Then call this shell script in any of the market available schedulers. The 2nd option is schedule these jobs using Data Stage director.

Answer Question  Select Best Answer

Seio

• Feb 25th, 2012

I'm interested in this answer because for any reason my jobs appear not compile after I begin the execution and I need an automatic process that auto compile the jobs when it founds uncompiled.

Thanks.

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 19th, 2010

If the job failed to compile, there must be some problem with the job.If the problem is not fixed then no matter how many times it is recompiled, the compilation will fail each time.Automatic recompile?option does not seem to be there in datastage.

Answer Question  Select Best Answer

the_xxx

 Profile Answers by the_xxx Questions by the_xxx

• Mar 20th, 2007

Transformer stage to identify and remove duplicates from one output, and direct all input rows to another output (the "rejects"). This approach requires sorted input.

the_xxx

 Profile Answers by the_xxx Questions by the_xxx

• Mar 20th, 2007

This is questions has got more answers as the elimination od duplicates are situation specific. Depending upon the siutation we can use the best choice to remove duplicates.1. Can write a SQL qurey de...

Answer Question  Select Best Answer