DSXchange

Hi, Our client is using data mirror in version 8. Want to know, what data mirror is used for? Is it the replacement of CDC stage? I still have not seen datastage version 8, going next week to client's place for development. Before that I want an overview about data mirror. I would appreciate some re...

Hello Friends I am trying to load data from a flat file into a teradata table. I have some date values in my flat file like RECEIPT_DT = 20070623000000 Which i am loading in a date type filed of teradata. I am using the modify stage for the conversion but its giving me an error. I am putting the val...

The scenario is, if any data exist in any of the datasets, the corresponding hardcoded value (in transformer) has to be captured in the target file. This target file will be used to run the job having that hardcoded value in its name. The above design is fixed across various projects and is working ...

We have a scenario, wherein we have 8-9 source datasets. After each dataset we have a transformer in which table_name is hardcoded. this transformer has only one column--table_name. We are checking that if any of the dataset is having data, then that particular table_name (from transformer) is being...

My another question is say suppose i have 5 records in the stati Table with values like QA_001 QA_002 QA_003 QA_004 QA_005. Is it possible to execute the multi instance jobs simultaneously with all the 5 above mentioned values. If yes what should be the design of my sequence. I don't want to hardcod...

Hi I have a scenario where i need to populate 50+dimension tables. The source is same for all the dim tables and the structure is also same for all the dimension tables. I have a static table with the following structure & values Attribute_Name QA_001 QA_002 QA_003 QA_004 QA_005 The naming conve...

Hi I am working on a project where we get standard template for working. I have a doubt with one of the templates so just wanted to share it with you to remove that. In job no.1 i am creating a dataset using hash partitioning which is used as a source in job no 2. and in job no. 2 i am using this da...

We have both character and numeric values in a field. We need to pick only numeric values from this set of values to insert into an oracle table.
Is there any function using which we can apply a constraint on this field in the transformer stage?

Hi, I am loading records into my 26 staging table using Load /Append option. The source for all the staging tables is their respective datasets and my taget is Oracle. For some of the staging tables all the records don't get inserted into the target table where as the Performance statistics shows th...

Hi, I am working on a development project of building a dataware gouse for a client. We created about 20 jobs. But today when i came i found 16 of my jobs deleted. I don't have a backup of them. Is there any way of retrieving those jobs and also can i come to know who exactly did that. All the devel...

Hi, I have a field where i want to populate records like 1,2,3,4 etc. I tried using sequence generator but its not populating the records correctly. I have 100 records so the last value that should go into this field is 100 but its populating a value which is more than 100. The configuration file is...

I have a job running successfully when run individually. But when I run the same job in sequence, it gives me an error 'Insufficient privileges'.
I am loading data from a dataset to an oracle table.

Hi I am trying to load records from a dataset into an oracle table using load method. But when i run the job it fails giving the following error ORA_PS_AZERITY_INVENTORY_ITEM_CDC,1: The system(sqlldr ETLLOADER@CORACDEVL66 CONTROL=ora.5451.353168.1.ctl LOG=ora.5451.353168.1.log BAD=ora.5451.353168.1....

Hi I am having two jobs. In the first job i am creating a dataset using Auto Partitioning. This dataset once created contains around 45k records, Its taking only 10 seconds in creating this dataset. In the 2nd job i am using this dataset as source to update an oracle table and the method i am using ...

DSGuru,

I have changed the value of scale to 0 but it's giving the same warning.

Ray:- Can you please elaborate it, I didn't get you?


Thanks