DSXchange

hi I did not get you . I am having 7 SAP tables and i am using ABAP_Extract_PACK_for_SAP_R_3 stage to extract data from these tables using joins.i will be using SQL joins to extract data from these tables .I want to know can is it possible.i see that this stage is like oracle oci stage. please share...

HI
i want to extract data from SAP.i am using ABAP plugins.
i want to know is it possible to extract by joining 7 tables usning inner joins.please let me know
THKS

Hi chulett
Thanks for your reply.i download the sample job for XML o/p from assential website elibrary .but it is not working.I cannot import that job.can you send me the manual for XML package_20_designe.pdf.
THKS

HI
My client want XML out put and source is oracle OCI stage.what are the things we have to consider .i just read the help docs.how to read 0/P xml
file in tabular form.
please do share your veiws.

HI
I want load only delta data(change) records into target.Is there any other way other than making target as lookup and update records.

Hi
Thanks for your replys.I want to take ecourse or classroom course on
server to PX .can you send some list who offer these courses in canada or USA.

thks

Hi
I want to move from server to parallel.what i should learn and can you search some key words for search in this forum.
thks

to stop and restart server here what i did but i am giving error

the connection was refused or RPC DEMAN WAS NOT RUNNNUG.
pl tell me what to do
thks

Hi I have a input string. ABC-1 DEF-2 etc. I have to insert 3 letter code in middle like ABC-OPR-1 DEF-NOP-2. which function i have to use. Hi Thanks for your reply. Based on if condition i have to insert either OPR or NOP in middle . i wrote routine MyString = Input_Data.GRADE_NAME MyString1 = Lku...

Hi
I have a input string.
ABC-1
DEF-2 etc.

I have to insert 3 letter code in middle like
ABC-OPR-1
DEF-NOP-2.
which function i have to use.
THKS

hi

we want to upgrade datastage to latest version 7.5.1.A.I just want to know is there any bugs in latest version.we want datatstage version which is compatable to oracle 10g.
pl share your veiws.
THKS

hi When i searched about row counts in this forum i got following codes. 1. $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF StageName = field (InputArg," ",1) LinkName = field (InputArg," ",2) RowCount = DSGetLinkInfo(DSJ.ME, StageName, LinkName, DSJ.LINKROWCOUNT) 2. ...

HI
Does any one used KIm duke;s ETL Sts job . to check row counts. from source data.how to use it.pl share your experince.

Hi
Every day we get data from different organizations.I wan to design ETL jobs to count the number of rows we get per month and compare with previous month .if there is drop in records it should notify.
I want to know how to design in Datatsage.please share your
valuable ideas.
THKS

HI For a perticular job in job sequence warning limit is set in following manner. 1In director . Job run requested Mode (row/warn limits) = 0/0 Job Parameters ---> 2.Run job options limit page is set to abort job after 50(default) warnings. when i run this job through sheduler it runs with 140 warni...