DSXchange

Did you try executing this in SQL Plus.
One thing we can try
Use positional parameter instead of =>
Remove the package constant and hard code it.

Ray do you have the data model of Xmeta?

It is not advisable to edit a DSX. But this is what could have happened in your case. 1) You have exported the job with executables. After you import just check the status of job in director. Guess it will be in compiled state. If this is the case export the job without executables and rename and tr...

Can you please confrim what is happening in the script that you have posted? ssh -i /aa/oracle/.ssh/rsa_cognos10_dsadmin test pfexec /ee/c10_cubes/script/Capital.sh set vReturnStatus = $status exit $vReturnStatus 1) $status - Will it have the return value or exit value of the previous executed comma...

I cant clearly show you the picture. One thing you can show as a proof is get the explain plan from toad. It will say Oracle is executing the sub query first and then executing the outer query. The inner query will be using Full Access i guess. Now from DS on each call records are fetched. So in tha...

Only few days back this was discussed. Guess the number of files are not more. Write the result of table execution in to a file comma seperated file. Within in the start and end loop acitivity, call the job for each file. Here is a solution provided by Ray & Craig http://www.dsxchange.com/viewto...

MTCN will never be char

Write you query as
select col1 from table where not col1 like 'MTCN%'

So there will be always two comma delimiters only. Change the schema as record {final_delim=';', delim=',', quote=none,padchar='#'} ( name: string[max=255]; col1: nullable string[max=255]; col2: nullable string[max=255]; ) In the transformer, based on the business rule map the columns to target

There are lot of option to get it done. But
Understand how the source team is generating data.

runtime i need to pick 1 key column and any 2 of those 3 columns

If there are values for only one non-key column will they send only one delimiter and to which column we will be mapping this?

Are you mentioning from the source the number of columns is 4 but the columns can have null values. Or not sure on number of columns? Anyway you can try as: If from source they cant provide 4 delimiters, then read the data as single column and split the data in to columns in transformer using field ...

If there are no other columns, and the column header is static, hard code the static value in transfomer constraint column as not equal to

Hi Ray,

Do you have any links that best explains the Data Rules stage

Since there is a IN clause in the query, the defined array size may impact this.

Just try this

select * from sample sa join staging st
on sa.id = st.id
where sa.unit='522'
and st.unit='522'

Can you please post the correct table names? I mean atleast different name and alias what u used

Automating with universe repository with the exploration i did, was not a reusable solution since the table names are not unique. And in the higher version of DS you may have it in different database. If you want to automate this, you can very well export the jobs with a command and use DOM parser i...