DSXchange

Use round robin after Source (which is sequencial) and Entire for every reference link.

You can mark the City as Key (Repeating Elements required=Yes). So that the output will be new line for every City.

I think your XML file is exceeding the length you are using to read the data. Try to increase the lenght of XML file column or I think instead of reading whole file as a LongVarChar string. You can use option XML PATH/URL in folder and XML Stage.

Stage 1:
Read First line by using SEQ file stage : [filtre : head -1]

Stage 2:
Read all lines except first in SEQ file stage : [filtre : sed '1d']

Lookup Stage to compare / drop non-matching records.

Use transformer Stage Property.

Surrogate tab.
SourceType = DbSequence.
Database = oracle
user / password / server.
Source name = your sequence name


=> Derivation: NextSurrogateKey()

I am having a problem while sending a message to webservice having repeating element. For exemple : Employees ID's is declared as maxoccurs="unbounded" <EMPLOYEES> <ID>123</ID> <ID>121443</ID> <ID>125553</ID> </EMPLOYEES> I am reading ID column as one value 123</ID><ID>121443</ID><ID>12555...

Split the file into multiple files using UNIX command for particular word count.

For example: File1.txt, File2.txt , File3.txt etc.

Use <File pattern> in sequential file stage => File*.txt

It will read all the data from multiple files as if they are only one.