DSXchange

when export file >>change file extention from dsx to xls

Hi Roy,

I am quite confused, how come you have difference in row count

Job 1 returns almost 130 million rows written to seq file (around 7GB file).

Job 2 returns all over 200 million rows written to seq file as expected (around 12GB file).

pls help to give some information

Thanks,
Krishna

you can transfer projects through excel ,txt file format too o. That's y datastage is great!

Surrogate key Stage one of property "Start Value" you need to parameterize through Job Properties and in your job design you need to write another Utility job to get Max id's and pass output value to current job in sequence design.

pls refer date function's in Parallel Job developer's guid page 1105
you can try DateFromDaysSince

regards,
krish

Hi

In transformer stage have you mapped correctly to date type field ?? Pls check, by right it should not give error. Should compile successfully.

pls try datetime data type in source and target and let me know.

Cheers,
Krish

you may try to use Basic functions ASCII or EDCDEIC converison function to Converts the values of characters in a string from ASCII to EBCDIC format or EBCDIC to ASCII format

cheers
krish

you may need to check envrionment variables!!

if your DB source is Oracle you can achive this at DB Select statement level Or if you are strick to do this at Datastage Level you can use pivot stage. i do prefer to implement this by using Pivot stage

cheers,
Krish

Hi All, Its simple in EE 7.5 . We have Datastage Plug-in Stage Command Stage The Command Stage is an active stage that can execute various external commands, including DataStage engine commands osh, programs, and jobs from anywhere in the Ascential DataStage data flow. You can execute any command, i...

Ok Mr. Ray. thanks

Cheers,
Krish

Hi

Thanks for your help. i would like to know how to integrated datastage jobs with version control tool.

cheers,
Krish

i think Mr.ray mean is in Oracle Enterprise Stage >Input tab> Properties tab>Target folder >one of Property is Write Mode is "Truncate"

You need to select Truncate property in Write Mode.


Ray ,please corret me if i am wrong.

Cheers,
Krishna

HI , I would like to know, Promotion process of Datastage jobs developed in DEVELOPMENT envrionment , how to promote to SIT and UAT and Production Envrionments? if it manuall promotion process i know we can do it by using IMPORT AND EXPORT methods, but is any best method of auto promotion process an...

Hi,

You may typecasting function StringToDecimal
Returns the given string in decimal representation
string (string)
[rtype (string)]
result (decimal)

Cheers,
Murali