DSXchange

You specified Parallel. For the parallel canvas at 7.x there are two Transformer stage types, called the Transformer stage and the BASIC Transformer stage. You need the latter. You'll find it in the Processing group on the Palette or in your Repository browser. Hi In my document i see the about the...

Hi folks,
I have a file which has specail characters. I have to remove all the specail characters and move in the info into another file.
So anyone have a clue how can i achieve this.
Thanks
VZMZ

Just setup a symbolic link to point to the appropriately named file. This allows your job to have a fixed name, and the symbolic link switches between files. An alternative is to copy the landed file into a processing directory under the fixed name. What is a symbolic link (is it another stage) how...

Hi friends, I have a file "xyz02182004", which come every month(i.e monthly). I have to design a job which will run monthly. I took a file stage on this file and started validation on this file using a transformation. The problem is this file name gonna change next month but the validation...

Yeah, yeah, yeah, my wife called me to dinner and I forgot to touch it up. It's done now. Is this doable to avoid seq files intermediate steps teradata Refrence table | | V Hash File | | V TeraData---> xfm ---> TeraData *note the upper link is shifted so assume the upper link going into xfm Thanks

Let's do some simple link naming to make things easy. Your job looks like this: hash | | V seq ---> xfm ---> seq If your link into the xfm is called "SOURCE" and your reference link from the hash is called "REFERENCE", then construct If-Then-Else statements like this: If SOURCE....

Write a job that extracts table A to a sequential file using the WHERE clause A.ACT_CUST_ACCT_NO NOT IN (SELECT DISTINCT ACT_CUST_ACCT_NO FROM CBSS_ETL.ACCOUNT); so that you only get the rows you need to process. At the same time, have a job extracting table B to a hash file. Lastly, have a third j...

Extract(Teradata) ---> Transformer ---> Load(Teradata) Use user-defined SQL in the Extract stage to extract from the three joined tables. This is MUCH easier - especially since you already have the SQL - than loading hashed files from the same database instance. The Load stage can use a generated S...

chulett wrote:Without going into tons of detail, there is an "IsNull" logical function so you could try using:

Code: Select all

if IsNull(DSLink.field) then ' ' else DSLink.field 

Nothing is ever "equal to" null.

Thanks
That was a valueable information

Hi friends I have a BTEQ script here (something like an PL SQL ) for Teradata. All that i have to do is convert this script into a server Job. If u see thier are 3 tables user and the forth table where i will do the final insert. How can i do this ? like what all stages i need and which stage should...

Hi friends
If i just put TimeDate() under a column will it take the current date time format

Hi folks I am trying load a fixed length sequential file into a TERADATA table. I have a field of 8 char length in format of yyyymmdd which is mapped to a date field in teradata. But the data in Teradata after the transformation is not in the same format. Is their any function that i can used and co...

The simplest thing is to let DataStage generate the SQL for you; depending on the stage type you are using there are between six and ten "update rules", such as "insert new rows only", "update existing rows", and so on. Feed the rows to be updated through a stage with ...

That's going to depend on a number of factors, none of which you bothered to tell us about. Let's call TableA the table that has to be updated, and TableB the table that contains the updates. Does TableB contain only records to cause updates to TableA, or does TableB contain these and other records...

I have a tables which have to be updated using another table (which have all the updated records)
How can i achieve it?