DSXchange

Hi Guys, I am trying to remove leading zeros from a numeric data which is coming in a Varchar field. Source data : 000275 Target Data : 275 Both the Source field and target field are Varchar Field. This is what i am doing. DecimalTostring(StringToDecimal(InCol), "suppress_zero") I am getti...

Hi Guys, I imported the metadata using the Plugin and used that metadata in my Oracle enterprise stage. The Credentials are all fine. When i tried to view data, i am getting the following error. ##F IIS-DSEE-TUXX-00002 04:00:51(000) <main_program> Internal Error: (colDesc):orautils.C: 1859: getColDe...

Actually i need three datasets and not all the recrods in one dataset.
I have modified my intial post..

The Change capture stage should be able to get this results,, am just guessing need to work on it..

Hi Guys,

I want to create three datasets from lookup.
Dataset1. Records present in primary and not in Reference.
Dataset2. Records present in both primary and Reference.
Dataset3. Records present in Reference and not in primary.

Can somebody help me with this.

Cheers!!!!

Hi Guys, I am getting Time in one column and Date in one Column. Both of them are char fields. I am concanatening them to form a timestamp using the below codel If StringToDecimal(Trim(SAP_to_Trans.ZCAT_UDATE)) = 0 then StringToTimeStamp('19000101',"%yyyy%mm%dd") else StringToTimeStamp(Tri...

I created a Execute command stage with "ls /path/Text*.txt" command in it.
Now How to pass it to the Start Loop Activity stage?

Sorry to reply back late,,, the problem is resolved..
The problem was with the Source data and not as Lookup data as i thought.

Now i am doing the lookup by Spliting the source column to the required length and looking up with the lookup column.

Thanks for your help and guidance..

HI Guys,

I have multiple files in a location. Now i need to process each file one after the another.

So, i need to pass the file names one after the another to a sequence.

Can you guys help me with this.

Cheers!!!!

exactly Ray,, even though my SQL is selecting only two columns, my second column contains data of both the second column contanated with the third column value. In table, N_CUST CSGNE 1203 011 1204 055 When running the job, i am getting for N_CUST values as 1203011 and 1204055... This is causing the...

why dont you concantante the columns with the required delimiter in the transformer itself..

This is the SQL i got from the Lookup stage. SELECT XRF_CUSTOMER_T.N_CUST_DWID,XRF_CUSTOMER_T.N_CUST FROM XRF_CUSTOMER_T WHERE XRF_CUSTOMER_T.N_CUST=:2 Also, when i am viewing data from the Oracle(lookup) stage, i am able to see only 2 columns and not 3 columns. But only during the run, somehow 3 co...

It is not a hashed file lookup. The metadata matches with the SQL in the second lookup.. Actually, in the database, col2 on which the lookup is done is varchar2(9) and in the job, it is defined as Varchar(9). Now, when the data from col3 combines with it, it exceeds that 9 character and it is throwi...

Hi Guys, My job is having 2 lookup on 2 tables. In the first lookup, i am pulling 4 columns from the total 64 columns present in the table. In the second lookup, i am pulling 2 columns from the total 3 columns present in the table. Now the values are coming correctly for the first lookup. But in the...

chulett,, sorry to be pesturing...

But when the job which ran successfully till change capture also had the same table.. but it didn had any problem there...

I am just tryin to understand the problem here..

Actually my job is working fine till the Change capture stage. I verified it by writing it to flat file. Now after the change capture stage, i am using a lookup stage to pull the remaining records from the source table based on the key field and change field. Now it is failing giving that error. I t...