DSXchange

Hi, I am running a simple script from execute command activity,which writes the the return value 0 when scripts complete. (Triggers :- ReturnValue <> 0 then abort) But it abort even if the return value is 0 as Reply from the script is 1. Please guide me how this reply comes in the picture.(please su...

Hi all, I have written a small script to load data from sequential file to table and kept that in After Job Subroutine.Script fails as table was not present in database but didn't abort the job. Job finished with warnings. I want the job to abort whenever the scripts does not run properly. Please h...

Hi All, If we keep Preserve Partitioning as Default(Propagate) in all the stages, Will it be able to repartitioning the data in next stage. For example: If i have 2 seq file ----- Join -------- Aggregator -------- Target Table. What will happen if Preserve Partition is Default(Propagate) .Join and ...

sorry it was typo i used @DATE instead of @DAY
Oconv(@DATE,"D/YMD[4,2,2]")

still i get "1968-01-07"??

Kamal

Hi all, I am using Oconv function to convert @DATE to YYYY/MM/DD format. As @DATE output is 15894 which is today's date "07/07/2011". But when i apply Oconv(@DAY,"D/YMD[4,2,2]") its gives output as "1968/01/07". Please suggest how these Iconv and Oconv functions works a...

Hi all,

I am getting a warning in all the jobs for all the nodes in the source stage of Teradata Enterprise.
"Insufficient blocks for partition 5. Reading suppressed"..
why this warning msg is appearing and it can affect my job o/p.

regards
kamal

Hi all,

I am getting a warning in all the jobs for all the nodes in the source stage of Teradata Enterprise.
"Insufficient blocks for partition 5. Reading suppressed"..
why this warning msg is appearing and it can affect my job o/p.

regards
kamal

but wat this unicode means here,

Hi all,

Why we use UNICODE extened type for char datatype,how its effect our data?


Regards
kamal

Thanx

It was jus because of the RCP.

Kamal

Hi I m transferrimg the data from transformer and surrogate key genrator to the funnel where it is showing a warning like [size=12 ]"fnl_Join: When checking operator: Defaulting "TGTBASE_RT" in transfer from "inRec" to "outRec"."[/ size] for all the coloumns....

Hi all, I have a problem regarding surrogate key, do we have any option in data stage to generate a surrogate key on the basis of some key coloum which are the part of unique primary index. records may come with same combination of those columns ,all those record should have the same surrogate key. ...

but i have restriction to use only Sequential file stage for the source.

Hi All,

I m converting a EBCIDIC file into the fixed width ASCII file ,but i m not able to view data in the source stage itself , how can i convert the above file ?