DSXchange

Hi, I have designed a job with below user defined query on Oracle stage. FROM APPADS.s_dim_store s LEFT OUTER JOIN APPADS.s_dim_store_vers v ON s.store_num= v.store_num FULL OUTER JOIN APPADS.s_ipm_store i ON v.store_num=i.SBUX_STORE_NUM When I am reading the data from source tables I am getting bel...

Hi fields "STORE_AGE_CLS_NUM" and "STORE_AGE_CLS_NUM" read as Varchar from source and cover to decimal using StringToDecimal. Thanks for your response Satyanarayana. But I can not use the StringToDecimal function here, because the warning is comming at source stage(While reading...

Hi, Job Details: Source and Targets are Oracle tables In source table some of the columns are defined as NUMBER and I have taken these columns metadata as Decimal[38] in Source stage. When I run this job I am getting below warning for all these types of columns. oraStore: When checking operator: Whe...

Hi, I have designed a job, In which one column is defined as Varchar in source and target(Both are SQL Server tables). Source table contains Null values for this column.I have taken in source and target this column metadata Nullable option as YES.When I am running this job this record is dropping at...

Hi, I have designed job with source and targets are SQL Server tables. Source metadata is Varchar and Target metadata is Numeric. I am getting below error, even I used the StringToDecimal conversion function. APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Error con...

NULL will be dropped because you can not transfer NULL into a not null field in DataStage. And primary key columns are ALWAYS not null. You need to intercept the null farther upstream in your job an ... Thanks your response ray.... Can you tell me in which case we can get the rejected records form ...

Hi, I have developed a job like ODBC->Transformer->Oracle->ODBC . Here I have enabled the output rejected records option in Oracle stage and I want insert those records in ODBC table. 1) In source I have taken a column value as NULL which is Primarykey in target table, In this case this record shoul...

Hi, I have developed a job(Seq file -> Transformer -> Oracle) form Seq file I am pulling the date column values(Some values are null also) which are Varchar data type and in transformer I am using the StringToDate function to convert these Varchar into Date type. When I am running this job I am gett...

The 'warning' is simply the fact that your update sql did not update any rows. You eliminate it by not sending updates for non-existent rows. Use normal ETL techniques - existing keys in a hashed file ... Thanks for response. This query is updating the records, the only problem is giving the warnin...

Hi, I want to update the data in SQL Server table, for that I have taken a job design as Sequentialfile(dummy)-->Transformer-->ODBC stage. In Sequential file I have taken some dummy data and passing it into transformer stage and finally I have taken the update query in ODBC stage. when I run this jo...

Hi,

By using ChangeCapture stage can we read and write the data in same table in a job.

Please suggest me.

Regards
Sridhar

Hi, I want to implement a query(A), Before this query(A) I want to implement another query(B) and After query(A), I want to implement one more query(C). In simple, like MSOLEDB stage(it consists Before and After tabs), I want to implement above logic in ODBC stage. Please suggest me. Regards Sridhar

Hi, I have a job designed with Seq file and Data sets are inputs to the Lookup stage and output of this lookup stage into Transformer stage. I am getting below warnings lkupProdCogs: Input dataset 1 has a partitioning method other than entire specified; disabling memory sharing. trnsBusDt: Input dat...

Error is "DSR.MetaGeta(GET.TABLES)(SQL Connect('Oracle_Sridhar','trainee005'))BCI Error:SQLSTATE=NA000,CODE=0,[DataStage][SQL Client][ODBC][Microsoft][ODBC driver for Oracle][Oracle] Please suggest me. My car won't start. Tell me what's wrong. We cannot diagnose problems reported as "there...

Hi,

When I am trying to import metadata from Oracle 10g to DS 7.5.1 Version , I am getting BCI error.

Please let me know , why I am getting this error and how can I resolve this.

Thanks
Sridhar