DSXchange

mmm...where did you get your info? ascential does not exists anymore it's IBM.

I have checked the job log and the parameters are the same values(user_id,passowrd,Remote server) which i am using to connect through Oracle Sql Plus. And i am using Oracle Enterprise stage to connect to Oracle. I am passing values into Userid,Password and Remote Server. Just curious,when you say O...

Well define "looks bad". Anytime you see data in target that don't look like what you expected it most likely a job design issue. Check your column definitions carefully.

Check your job for the metadata (column) definitions and making sure you are not passing NULL values to the target.Your target field does not accept a null field that's being passed to it.

... If you rename the column in Join input stage, output stage of the previous gets changed, and hence the actual rename is happening in the previous stage. Agree. So if a rename was made, and I see it, why wouldn't it be enough to accomplish now a join on columns that have identical names on the i...

Hi, I want to check whether the string contain control character /Unprintable character in it. How do i check in the transformer stage . Is there any function is there to check the same?? Can i check by their Ascii values ??? But how in DS. Regards ~Nirmal You can use the "od" command out...

Hi What is the difference b/w before & after job routines in Datastage? And when we will use those routines in datastage jobs (i.e. tell me situations when we are using them in datastage jobs and why) thnks venkat there are many different situations where you might consider using it, most time ...

Bummer. We were hoping for something more dynamic. Grab a dataset, look up its info and write it out. Oh well. The problem is that we have potentially hundreds out there. Brad. Not sure of your requirements but I'll def look at RCP. Have you thought of using RCP in a generic job to move your datase...

There are overlaps in functionality between a number of DS stages, copy and modify stages are just one example.It's just a feature of the product. That is the reason why you find the comment in the User Guide that there are many different ways to do something in DS (or something along those lines).

Hi Guys, How to create a table with some columns having default values in create table statement. Now how to create a job to load data using Teradata Enterprise in this table without having default columns in source data. -Aim is to find out how DataStage behaves when we have created a Teradata tab...

Hi,

You should still check the Oracle Env variables. Being able to access another oracle database does not mean anything.
You could have 2 oracle home directories e.g due to upgrades etc and your DS is pointing to a different one.

Just my 2 cents.

rgds

I think the confusion here is around semantcis of the words "Fast Load" ; In the Teradata world, Fast load is the name of their utility that loads only to a non-empty table. When IBM developed the Teradata Enterprise stage, they worked with Teradata to make a fast load that can append to a...

Hi, I am running a job that process 3.5 millions rows ,reading from a file and after processing inserting to DB tables. When i run that Job with Node 1 then its is running fine but when i try to run it either by Node2 or Node 4 then it aborts with an error message: Message: APT_CombinedOperatorCont...

Have you tried removing that character from your file and check if you can now read the rest of the record ?

one other option is to split your jobs into a "prepare" jobs and generic load job. the prepare jobs land data into datasets. then apply the loads in batches.