DSXchange

I like to know what are the options available for incremental loading in Parallel version. I know the CDC is one of the option in which we can capture insert, update and delete. Please let me know the other options. In which design we can it as reusable design? My source is Oracle and Target is SQL ...

Hi,
how we can transform oracle tables to xml s

Thanks in advance,
Subhani

Hi,

what happens when we execute these below commands in scripting:

1. cat $Job_Timestamp_file | grep jpmTimeId | cut -d"=" -f2 | sed /s/ >$Job_Timestamp_file

2 tar czf $dest/$archive_file $backup_files

pls can any one explain

Thanks in advance
subhani

Hi,

when running the script from command line.....getting this error..........

invalid arguments....


status=0

pls help


Thanks in advance,
Subhani

Thanks for u r help michel

Regards,
Subhani

hi team, what output we will get when we execute this query...pls illustrate SELECT AUM.iResourceType, AUM.nvcMessageTitle, AUM.iMessageSeverityType, AUM.nvcMessageText, AUM.dtMessageTime , AUT.RefFlag, AUM.iMessageId, 'CFF:' + '#ARC_VersionNumber#' as Version, '#ARC_DeviceVendor#' as DeviceVendor, ...

my source sequential file has 10000 records,now in transformer stage i want to abort the job after 8000 records loaded to target ,what we have to do............. we have to give any function <@inrownum>8000 then .....is not working...............what is the function to abort pls tell me thanks in ad...

i have 400000 rows,the job was aborted while loading 300000 rows...i don t know why it was abrted....what we have to do.......urgent...........


thanks in advance.......
subhani

ray.wurlod wrote:Using what kind of job? This is important - it's done in different way in different job types. ...

....IN PARALLEL JOB

just read from it?how?

new to unix environment....
how can i open the job through unix...what are the steps to be followed?
thanks inadvance..........

subhani

hi, i have parent in hierarchy having 2 childs.....this chain continues upto 25 th level..one company is on 9 th level,8th level is parent of 9th,7th to 8th....like....1st to 2nd...........now how can i track the records?what is the logic used in stage? thanks in advance..........waiting for reply.....

hai,
i am new to autosys,in our project after designing the job and scheduled using autosys ,i got an error

how can we rectify the error in autosys?could anyone help me....

thanks in advance,
subhani

i have 2 sequential files in which
one file having firstname,lastname

2nd file having firstname,e-mailaddress

now i want output as
firstname,lastname,e-mail-address...........how?

i used join stage join type as inner it does n't work...

table1 has a1,b1,c1 and table2 has a1,d1,e1...........

now i want table2 only in which table1 values should not be there ......how?