DSXchange

Hi, am tring to exeute a job through unix, for that i wrote a simple script for callling data stage job. script is throwing error and saying -parm : not found. can any one tell me any thing wrong in my script. #!/usr/bin/ksh # this script is used to run datstage job /opt/Ascential/DataStage/DSEngine...

Yes , for some jobs today only am getting this kind of issue

Is there any problem with C++ compilers?

jobs only having transformer stage taking long time to compile

Hi,

am working in 7.5.2 PX Edition, when i compile the jobs its taking long time (more than 20 mins for single job).
could you please any one do some need full

Hi, when i tried to load the data into SQL SERVER tables am getting a below error messages : [[/quote]FIReferenceTableLoad..TB_DI_SZ3_FI_D_FACT: OLE DB provider error: The statement has been terminated. FIReferenceTableLoad..TB_DI_SZ3_FI_D_FACT: Failed to commit final row(s). [quote] Can any one giv...

Hi, Am just trying to load the data into Table by using SQL Server stage(Target database), a simple job having three stages fetching data from file loading into table Transformer is placed between . none of the records got loaded into SQL table got warning like : OLE DB provider error: Invalid chara...

Hi, In my project some of the jobs we are going to migrate server edition to px,we have an issue with hash file while migrationg we are aditinally building a one serverjob and one parallel job new , which loads hash file data into seq file then seq file into dataset. is there any other way to implem...

Use sort stage and apply the property create cluster key col is true , then you can get the aditional fileld with 0 and 1 after that you can filter both unique and duplicate records

Thanks its working fine...

Hi ,,
could you please tell me is there any function in datastge that subtracts days from date
for ex: if date is 21-04-2010 then output should be 20-04-2010


thanks in advance...

you can handle these kind of things by wrinting user defined sequel in your source stage if you are using oracle is source database.
oracle 10g supports to write a sequels in order to get data in hierarchical order by using sys_connect_by_path, level key words.
which might helps you

HI ,

could you please tell me what is VOC? how it is useful to datastage? and how to check?

i never heard about VOC earlier, could you please help me out.

Hi,

Any one Let me know is there any way to Trim the values by Using Modify stage in Parallel.

Thanks in Advance...

hi ,

any one could you please let me know how to connect to the uniVerse shell to execute SQL commands?

Thanks in Advance...

[* Note - Title corrected - Andy *]