DSXchange

Hi, The defualt value coming from netezza, but unidentified what it is and some times will come blank(null) and some times come withe data like '1/100 ??'. but i need data cleanse in datastage, i used pad string and convert functions. But unable to remove that kind of data and yellowbricks not accep...

Hi We are loading the data from netezza to yellowbricks but getting below error. ODBC_Connector_15,0: ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 3452617: Msg = [IBM(DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: invalid byte sequenc...

" if exists " not working for yellow bricks we modified the job logic, instead of one job, splitted the job and impleted the ifexist logic.

Hi, I am trying to run below query in odbc_connector(before sql statement), facing issue. Loading data from netezza to yellowbrick. and same time create statement table in before sql and insert table is same, failing job in this scenario also if both names are same, working fine in netezza connector...

Hi,
Please provide me the information , if any one using or having an idea how to connect yellow bricks database in datastage tool

It is DB2 data, let me show an example

VARCHAR(5) data "ABCD" moved to CHAR(5) now data "ABCD " in the 5th character junk will happen instead of space.

Hi, My source having CHAR datatype and target has VARCHAR datatype. While moving data I am getting junk character into target. Same thing s happening while moving data from VARCHAR to CHAR. One of the options is to trim the column through out the job, but I need a better option. Please suggest how t...

Hi, I am trying to extract the data from xml file, i tried with the one of the online file (books xml file) with the XML stage, retrieving only the first row and remaining rows are not populating and not showing any warning or error, Same file tried with the XML Input stage, it was working fine and ...

Hi, I too facing same issue as noted here. Using RCP in my job without defining the columns in job , executing the job with schema files, if i use only Insert job working fine. If i use update then insert with the key's(columns in file) throwing same above error, could some one suggest how to resolv...

Hi, We are trying to pull the data with different metadata, for that taken below steps. 1. Sequencial file --> providing file, schema_file and enable RCP 2. Transformer -- > enabled RCP and no columns are mapped 3. Sequencial file---> Target We are getting the count in perfomance statistics, but not...

Hi,
I have XML file, which contains two xsd's columns, no idea how to work with two xsd's .

one xsd calling internally one more xsd.

From reference getting distinct records.

Hi,
I am using lookup, from main Stream getting 3582, and from reference getting 112 records , but lookup output 16201 records.

Using continue( left join), if we mention continue output should match 3582.

Please help me out, if some one faced this kind of issue

Hi, I am trying to execute the ds job through command line. when i am trying include the parameter set in the command line job is triggering, but if i include env variables in the command line job is failing. 1.Please let me know how to run command line with env variables. 2. Please let me know how ...

Hi, My requirement also same like this requirement, getting multiple .xlsx files. Can i know how the template looks? My requirement : 1. Getting multiple files and read it into text file 2. In target we have max 100 columns, but each file has different column counts, Example: file1 contains 10 colum...