DSXchange

I am currently working in a datastage migration project 7.5 to 8.5 As part of code migration process we have 1000s of CoSort scripts also which needs to be migrated to the new Linux server. To avoid licensing cost for CoSort the plan is to convert the CoSort scripts in Datastage Parallel jobs. Strat...

We have alreadt enable quote identifiers option in the teradata connector stage(In Datastage 8.5) its not working since we have "SOUNDEX" in the value statement of the insert query(ORACHESTRATE.SOUNDEX) which won't be in quotes right, there its showing error. Can we have something like &qu...

we are using a generic job for loading the data from sequential file to a teradara(using RCP and schema file). In our schema file we are having a field as "soundex" which has to be mapped to the target teradata table "soundex". we can able to create the table in teradata by putti...

I am creating a fixed width file and i have set APT_STRING_PAD_CHAR to 0x20 value. I think this is the issue with the AIX server while dealing with the files of huge record length. In AIX system, when i am using this command "head -1 file_nm | sed 's/\000//g'" --- the output is displaying ...

Ys its a NULL terminated string... when i remove COB_COMMENT field and appending other fields in place of it... it's adding NULL terminated string at position 4095

Hi datastage experts please look into this issue...

My Job is creating a Fixed Width which is having record length of 4703. The file is created successfully with some NULL Character at positon 4095. I thought this might be coming from the Source table(Oracle) but i didn't find it any there.There is a field COB_COMMENT which is spread across 4095. I h...

In the same job i cannot able to add any more extra links to the transforner stage... and i have copied that stage and pasted in another new job still i cannot able to add any links to it... which is veru weird... And Ray, the transformer stage name has been renamed... so on the title bar it's given...

The multiple links are used as Source & Reference as in lookup stage or (transformer stage in Server Job). I have checked few things :- 1) the execution mode of the stage which is parallel 2) I can see the parallel routines from the transformer stage 3) I didn't see the EREPLACE function in the ...

I am in a production support cum enhancment project where i came across few datastage(version 7.5) PARALLEL jobs which is having multiple links to the transformer stage. I can add multiple reference links to the transformer stage which is very strange which i found. I thought its the BASIC tranforme...

I am in a production support cum enhancment project where i came across few datastage(version 7.5) PARALLEL jobs which is having multiple links to the transformer stage. I can add multiple reference links to the transformer stage which is very strange which i found. I thought its the BASIC tranforme...

did u "refresh the repository" and checked for the 1st case???

Make sure you have ORACLE_HOME and ORACLE_SID variables properly set for the environment.

then use sqlplus -s username/pwd comnd for logging
after that u can just type SQL cmnds directly.

e.g:-

sqlplus -S $user/$pass <<EOF
SELECT * FROM tableName;
exit;
EOF

You can write a shell script for the dynamic pivot. I have one you can use this as reference and change accordingly #!/usr/bin/ksh ########################################################################### # # # Script Name: DynamicPivot.sh # # # Input: DynamicPivot.sh {Input File Absolute Path} # ...

You can do by modifying your job design a bit....
Use a look up stage to match your source to target before loading.
If the records are existing only pass those records for updating to target.
Like change capture stage.

This will work try it.