DSXchange

QUERY Select col1, col2..col18, Null as col9 from .... where.... in Oracle enterprise stage. and for the attribute 16--sql type is varchar and length is 150. when i run this the error i get is "main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: In field &qu...

In My Job, for a single column i have the option of using either left,right functions (column is date column) or type conversions (stringtodate, dateto string). i can use any of these to populate the date columns. Now my question is will there be any performance degradation if i use type conversions...

chulett wrote:In the Designer there's an icon that looks like the Internet Explorer icon - click on it.

Thanks. the generated HTML code was awesome. i like that.
Thanks again.

Generate the HTML job report from the Designer and copy out whatever you want from there. Or if you have the metadata saved in the Manager 'Table Definitions' - double-click on it, switch to the Layout tab, right-click in the data and select 'Save as html file'. Thanks But How can i generate HTML o...

how can i copy the metadata from input of the transformer to a notepad file. Is this possible. Or else can i print the metadata of a stage onto a paper.

I have some number of rows. I dont know how many rows i will get from the table. But on the available data i should make some changes leaving the first and last record. I should transform the data which is between the 1st row and last row. How can i accomplish this.

I have a question. i would like to concatenate30 fields which i will get from input. To concatenate i dont like to use a transformer. Is there any other stage in Parallel extender which aids me in concatenating. Only requirement is to concatenate and i transformer should not be used

Suppose the data is in this format ---yyyymm ex---199012 (year--1990, month--december). Now my question i have to fetch the last day of the this month in 1990 year. given 199012---get last day of month 12 year 1990 given 200203--get last day of month 03 in ear 2002. can you please help me how can i ...

Thanks for the reply.
Can you please give me the specific function with which i can access the last day of month. i looked for it in documentation but i didnt find it. Please reply

i have a value in a single column of dataset. can i pass this value to any parameter f my job

IF i give a data(200012) in the format (yyyymm). can i get the starting date and ending of that respective month. In this case can i get the starting date of 2000year december month (ofcourse starting day for all months will be 1, but is there any function) and ending date of 200year december month(...

I have a strange problem (i guess). In my sequencer i have 10 activities. Is there any way i can run only 6 activities and skip the other 4. Or i can run any 7 activites and skip the remaining. i dont want to run all the activities in sequencer. for some parameters some activites should run and for ...

I know that when copying one dataset to another location with ds extension we use orchadmin command. But when i tried to copy a sequentila file to another text file with an extension txt IT ONLY COPIES THE DESCRIPTOR FILE. i dont know how this descriptor came from. Do sequential files also produce d...

I am able to extract the data using oracle enterprise stage parallely.what i am doing is under Server options: partition table is name of the table, query is user defined query and i have written a query. when i compared the counts produced when i extracted paralley with the extracted count produced...

I did the same thing using "orchadmin rm -f controlfile1.ds controlfile2.ds controlfile3.ds" in execute command activity. It is working. Is this wrong approach command line:orchadmin rm -f parameters:controlfile1.ds controlfile2.ds controlfile3.ds Please tell me abt this approach and anyy ...