DSXchange

Could anyone throw inputs?

Hi Everyone, So far in our project we have been using ABAP_Extract_Pack_for_SAP_R_3_6 stage to access SAP BW tables/SAP ECC tables and load into data warehouse. Now we have got a requirement to call SAP function modules directly through datastage and captures the return data ( Not sure with the word...

Yes we do have unique key contraint on the table. Doesn't datastage and oracle considers those records as two different records? The job design is of SCD Type 1 and SCD stage is not considering as new record compared to already existing dimension record .let's say source has those 2 records and dime...

Hi,

Below are the address records in source and Datastage is treating both the records as one though there is an space after HB. Is there any way DS can load both the records into target oracle table.
Thanks in Advance.

Hi,

I did try to do the to_date conversion. It worked for the timestamp field, but it didn't work for the date field. For the date field it is giving the same error.

The data types of the operands for the operation "" are not compatible. SQLSTATE=42818

Hi, We are using 8.1 version of datastage. I have parallel job in which i am using db2 connector stage to connect to DB2 Database which is the source. Iam trying to load the data into a file. so there are no other stages except the db2 connector stage as source and the sequential file stage as targe...

Hi, I need to loop the datastage job by passing the values from a text file which is delimited by comma to the where clause in a user defined SQL having two parameters. Sample file : JOHN,US APPLE,UK ADAM,INDIA Sample Query: select A,B from table where NAME='#jpparm1' and COUNTY_CD='#jpparm2' In fir...

Hi, I need help in grabbing the value after comma from a comma separated file in linux. Values in a file : ABC,0 DEF,1 GHI,2 FJK,3 I need to grep value 0 if i pass ABC as a parameter to command. i tried with grep 'ABC' filename | awk '{print $1}' but unsuccessful. Could any one please help me. Thank...

Hi, We have designed SCD-2 model maintaing the history in dimension tables. Now a requirement came up to include current value for the attributes. ( SCD-1). For this we are planning to add new attribute for each and every SCD-2 attribute to the dimension table so that the current job maintains the s...

It worked with Oracle EE stage,but not with connector stage.Not able to figure it out why connector stage is not working I've tried with sample data say less than 10 records and worked without any issues.But actual table is going to have millions of records (10 - 50 millions) and it's taking more ti...

Ok thanks for your suggestion. I will split the job into two. 1st scenario upserts in one job and 2nd scenario upserts in another job and let you know the results.

Hi, We are using third party scheduling tool to schedule datastage jobs. We noticed that datastage jobs are not exposing the errors to scheduling tool. In other words when datastage job aborts ,the abort return code is not passing to scheduling tool to abend the JobA(JobA -- is a scheduling tool job...

Hi All, I have a requirement to inserts records into oracle table based on 2 scenarios.Table has 30 fields and 15 fields were defined as Unique keys created unique indexs. Scenario 1 : --- Process records with specific indicator (15th field) say <> 'V' Need to upsert records (have to update 14th and...

Hi Everyone, I have a job design which pulls data from source compares with old data using change capture stage and then performs inserts/updates/deletes. Design: Oracle EE stage ( OLD DATA ) | Source (Oracle EE stage)---> CC ---- updates/inserts/deletes.(Oracle EE stage) Apart from these stages job...

Is Web Services Transformer stage an option here?