Search found 33 matches
- Wed Feb 25, 2004 11:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Control Character
- Replies: 10
- Views: 5735
I just can't find it
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...
- Fri Feb 20, 2004 10:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Removing SpecialCharacters
- Replies: 3
- Views: 2761
Removing SpecialCharacters
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
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
- Wed Feb 18, 2004 3:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File Stage
- Replies: 4
- Views: 2221
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...
- Wed Feb 18, 2004 2:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File Stage
- Replies: 4
- Views: 2221
File Stage
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...
- Tue Jan 20, 2004 7:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Script To A Server Job
- Replies: 11
- Views: 5702
- Mon Jan 19, 2004 7:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Script To A Server Job
- Replies: 11
- Views: 5702
- Mon Jan 19, 2004 5:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Script To A Server Job
- Replies: 11
- Views: 5702
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...
- Mon Jan 19, 2004 4:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Script To A Server Job
- Replies: 11
- Views: 5702
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...
- Mon Jan 19, 2004 3:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to check for nulls in transformation
- Replies: 5
- Views: 2992
Thankschulett wrote:Without going into tons of detail, there is an "IsNull" logical function so you could try using:
Nothing is ever "equal to" null.Code: Select all
if IsNull(DSLink.field) then ' ' else DSLink.field
That was a valueable information
- Mon Jan 19, 2004 3:09 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Script To A Server Job
- Replies: 11
- Views: 5702
Script To A Server Job
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...
- Tue Jan 13, 2004 4:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to insert a Current TimeStamp ina field
- Replies: 3
- Views: 1998
how to insert a Current TimeStamp ina field
Hi friends
If i just put TimeDate() under a column will it take the current date time format
If i just put TimeDate() under a column will it take the current date time format
- Mon Jan 12, 2004 9:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: char to Date
- Replies: 1
- Views: 1240
char to Date
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...
- Mon Jan 05, 2004 6:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Finding the Updates
- Replies: 9
- Views: 5070
- Mon Jan 05, 2004 1:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Finding the Updates
- Replies: 9
- Views: 5070
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...
- Fri Jan 02, 2004 9:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Finding the Updates
- Replies: 9
- Views: 5070
Finding the Updates
I have a tables which have to be updated using another table (which have all the updated records)
How can i achieve it?
How can i achieve it?