DSXchange

thanks deepak

but i am looking for this output through combine stage

HI All,

please share how to use the combine stage for the below scnenairo

source :
id | column
1|10
1|20
1|30
2|10
2|50
3 |10
4|20

target
1|10,20,30
2|10,50
3|10
4|20

IDOC is intermediate documnet used to load the SAP system

Hi

I would appreciate if anyone tell me how could i load data from sequential file to an IDOC

HI pandeesh,

i really don't know why you are getting this result i am getting exactly the same i have mentioned in previous post . i have tested it again.

hi
with the help of 3 stage variables you can achieve the desired result
stgvar --> input column
stgvar1 --> stgvar2:'/':stgvar
stgvar2 --> stgvar1

the only thing is the result will come in the format
/a
/a/b
/a/b/c
/a/b/c/d

so you can remove that the first / easily

I think you need A-B type of record if it is so then you can use the merge stage and the reject link will conatin the A-B types of record

so u have used the aggregator and u r taking the record count of it in transformer you can apply two constraint recordcount > 1 and record count = 1 through this you will get the unique records in another link add a lookup stage and take a lookup with the same file u r using intially use lookup with...

Hi i am using the xml input for that i am putting evrything in sequential file in one column and then passing it to the xml input stage and then again to output sequential file so always the input will go in one row(as i am putting the the things in one column also source is not providing me multipl...

you can use the unix script to split the file using the sed command and later load the spiltted file to target

use the aggregator stage
group it by according to the key column
count the no. of rows by using the count row
now in transformes stage use the constraint .....linkcount = 1 (for uniques)
and linkcount > 1 (for duplicate)

Hi


in my job i am taking the records(63 lakhs) from one oracle table and putting them in one XML file it is aborting with the error
APT_CombinedOperatorController,0: Operator terminated abnormally: received signal SIGABRT
note :i am running my job on the default node

please suggest

Hi

I have added a reject file while doing this insert and in that reject file i am taking the sqlcode as one column

Hi

when i am trying to insert records in oracle enterprise i am getting the sql code as 1480
the column in which i am trying to insert is a varchar and length is 4000
i also tried the APT_STRING_PADCHAR = 0x20,0x10 but its still giving the same
please suggest!!

for the second thing you can use the aggregator and then use where link count = 1 in the transformer constraint