DSXchange

Hi The below one is the exact query that i have used SELECT HIERARCHY_ID, EMPLOYEE_NO, (SELECT CAST(DATENO as INT) FROM owner.DATE_HIERARCHY_DIM WHERE to_char(EXTERNAL_DATE ,'YYYY-MM-DD') ='2008-09-03')DATENO FROM owner.FIN_HIERARCHY_DIM WHERE ROWID in(SELECT MAX(ROWID) FROM owner.FIN_HIERARCHY_DIM ...

[/code]SELECT
column_name1,column_name2
FROM table_name1
WHERE ROWID in(SELECT MAX(ROWID) FROM table_name1 GROUP BY col1,col2 HAVING TO_CHAR(col2,'YYYY-MM-DD')='2008-09-30')[/quote]

Hi , I am using the ROWID in the user defined sql query .. When i execute the query from the SQL client its working fine and when the same is used inside the Oracle stage its showing the following error sqlcode is: -1756 esql complaint: ORA-01756: quoted string not properly terminated I used the sam...

Hi , I am having aroung 124 columns in my before and after dataset. During change capture ,i am getting some rows as Edited but i could see that the data is in sync in both the before and after dataset . How do i detect in which column(s) the change has happened. During Run1 of my Change capture all...

Hi, The addition of a space again at the end of the values would still treat them as a update records as the file will not have any spaces to the value column...I would like to read these records from the oracle table itself without any spaces. as i have about two hundred columns to trim and check. ...

Hi , I am having source as a mainframe file containing char columns and staging the mainframe file into the oracle table without any transformations. during the next load , i am doing a change capture (explicit keys and all values)between the file and the staging table and loading only new and chang...

Hi ,
There is no resolved post or workaround post.. But there are citations that using load option can lead to this problem ... Hence thought of an alternative way by changing that to upsert...

Any clues on the post

Any clues please on the post

Hi , one solution to this prob is that i can disable the load and use the upsert method but there is an problem in using this option. I have consecutive spaces in non nullable char column which when inserted is treated as null and job aborts . I went for this load option with Oracle_preserver_balnk_...

Hi , Also there is a mistake in my issue specification . Actually i am using the change capture after the modify stage . The After and Before datasets are not in their proper metata. . I am converting the After dataset metadata ( which is extracted from mainframe) using the modify stage to be in syn...

Hi,
There is no conversion function exists for int64 to int 32 conversion .. I had a look in the parallel job developer guide as well as i have searched the forum .....

Any clues please

Hi, I am getting the following warning in the modify stage .How do i handle this type of conversion . can i demote a data type from its higher width to lower width? any clues to remove this warning Implicit conversion from source type "int64" to dest type "int32": Possible range ...

Hi ,
I am loading the oracle table with the write method =load and and rebuild index option ..I am getting this wird warning from the DB stage in the log. Any clues to remove this warning

Hi , I have converted the decimal cols to string cols using the string_from_decimal in modify stage. The metadata on the target is string[12] and hence the output of the modify page i have given the metadata as string[12]. There are no warnings thrown in the modify stage but the down stream stage ha...