xtremer185

 Profile Answers by xtremer185 Questions by xtremer185

• Aug 30th, 2006

First the drive in which you are going to install should be in NTFS format.Then the installation is pretty simple like normal s/w installation.Then u should have date,cpu count,activation code.tat's al .

Answer Question  Select Best Answer

Shiva

• Aug 25th, 2006

Hi allThe above answer is wrong ,if checkpoint run is selected then it will keep track of failed job and when you start your job again it will skip the jobs which are run with out erors and restart the failed job,(not from the record where it si stopped)

kishorek25

 Profile Answers by kishorek25 Questions by kishorek25

• Apr 9th, 2006

By specifying Checkpointing in job sequence properties, if we restart the job. Then job will start by skipping upto the failed record.this option is available in 7.5 edition.

Answer Question  Select Best Answer

srividya

• Aug 25th, 2006

You can as well export the Datastage jobs in .xml format......

Pavan Nadiger

• Aug 23rd, 2006

.dsx is the standard file extension of all the various datastage jobs.Whenever we export a job or a sequence, the file is exported in the .dsx format. A standard usage for the same can be that, we dev...

Answer Question  Select Best Answer

Bunny

• Aug 24th, 2006

CLEAR.FILE &PH&

Govindarajan

• Aug 2nd, 2006

REmove log files periodically.....

Answer Question  Select Best Answer

praveenkumar

• Aug 20th, 2006

If we want to send more data from the source to the targets quickly we will be using the link partioner stage in the server jobs we can make a maximum of 64 partitions. And this will be in a...

Answer Question  Select Best Answer

Ram

• Aug 16th, 2006

Thanks

Anwar

• Aug 14th, 2006

Hi Basically Environment variable is predefined variable those we can use while creating DS job.We can set eithere as Project level or Job level.Once we set specific variable that variable will be ava...

Answer Question  Select Best Answer

Pradeep Menon

• Aug 8th, 2006

Use the Stored Procedure Stage

Answer Question  Select Best Answer

sudheermukkamalla

 Profile Answers by sudheermukkamalla Questions by sudheermukkamalla

• Aug 8th, 2006

Explain

Zabi81

 Profile Answers by Zabi81 Questions by Zabi81

• Jun 1st, 2006

Hi,Which stages u r using in the Server job.  If u r using ODBC stage, then u can write User defined Query in the source stage.If u need more details, i can explain u.

Answer Question  Select Best Answer

Srini

• Aug 1st, 2006

Using dsjob command,-optionsdsjob -run -jobstatus projectname jobnameThanks,Srini

Answer Question  Select Best Answer

vijaya kumar peruri

• Jul 27th, 2006

if your environment is unix , you can check with wc -l filename command.

Answer Question  Select Best Answer

soumita deb

• Jul 25th, 2006

This can be achieved by "Direct Load" option of SQLLoaded utily.

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

laxman

• Jul 24th, 2006

Transaction Size - This field exists for backward compatibility, but it is ignored for release 3.0 and later of the Plug-in. The transaction size for new jobs is now handled by Rows per transacti...

Answer Question  Select Best Answer

Benny Lim

• Jul 21st, 2006

You may convert the Ascii Code using IBM DB2 tools. Or Setup linkage via ODBC connectivity thus loading from table to table.Of course, DB2 can extract to plain Ascii Text.For your info, Datastage loading from textfile is faster than table loading.Good luck.

Answer Question  Select Best Answer

sreedhark

 Profile Answers by sreedhark Questions by sreedhark

• Jul 14th, 2006

hi thanks for response and sending that answer.can u send me that unix script for getting and implementing sqeunce number in file names. 

Guest

• Jul 13th, 2006

This can be done by using unix script 1. Keep? the Target filename as constant name xxx.psv2. Once the job completed, invoke the Unix Script through After job routine - ExecSh3. The script should get...

Answer Question  Select Best Answer

vimalt

 Profile Answers by vimalt Questions by vimalt

• Jul 13th, 2006

The stages followed by exception activity will be executed whenever there is an unknown error occurs while running the job sequencer.Thnx,Vimal T 

Guest

• Jun 29th, 2006

It is used to catch the exception raised while running the job

Answer Question  Select Best Answer