DSXchange

Hi Ernie,

I am not able to view your post completely ( I am waiting for my premium membership to be renewed)

Is it possible for you to allow me to read your full post

Hi Ray ,

All the three files ( Header,Detail,Trailer ) has different meta data

Will it be possible to use funnel in this case

Hi Ernie, I am not getting single row for Header and Trailor If I just load the Header fields to a text file, I am same header reords that is equal to the count of detail records ( I think this happening because I took detail file as main while doing left outer join ) Is there any way ( at XML / XSD...

Hi Ernie,

Thanks for this

you don't have to do all the lookup stuff

If there is any other easy way, can you please let me know

Regards
Ram

Hi Chullet,

We don't have any Pre defined output

We were asked to come up with a optimum design to create an XML ( from text files ) with Header, detail, Trailer in it

Hi Ernie, Thanks for your reply Apologies , my premium membership is expired and i couldn't see your post completely . Let me tell you what i have done , I have created a Dummy column in all the three files ( Header, Detail, Trailer ) and did a left outer join using Details as my left link . I am ab...

Hi All, We were tasked to create an XML with Header, Detail, Trailer Our source is text files and we have 3 input files ( Header.txt, Detail.txt, Trailer.txt) , we need to create an single XML file with all the three mentioned All the three files are having different metadata We need to create an si...

Hi All, We are in the process of re building our Environment by installing IIS 8.7 . Right we are having 2 enviornments 1. Ap1 - ( Services & Repository tier ) 2. Ap2 - Engine tier Our Db2 ( Xmeta and IADB) is installed on Ap1 . Below are our questions ( with regards to creating our Transaction ...

Hi All,

I got this problem sresolved by appending Port number to the Servername


/IIS/InformationServer/Server/DSEngine/bin/dsjob -domain detldb1N:9080 -user c35430133 -password c35430133 -server detlap1n:31548 -lprojects

Thanks for your support


Regards

Hi All, I ran the command grep dsrpc /etc/services , and below is the output ad1dsrpc 31538/tcp # RPCdaemon DSEngine@/IIS/InformationServer/Server/DSEngine ab1dsrpc 31548/tcp # RPCdaemon DSEngine@/IIS/InformationServer/Server/DSEngine is it correct to have two entries for dsrpc ? On the other server...

Hi , Thnaks for you rsuggestion I tried to run the below command /IIS/InformationServer/Server/DSEngine/bin/dsjob -domain detldb1N:9080 -user c35430133 -password c35430133 -server detlap1N -lprojects Below is the output Status code = 81016 Same command is getting executed in the dev box with out any...

Hi Chullet, With the same command we are able to run on the dev boxes . With User names and passwords , below is the error message /IIS/InformationServer/Server/DSEngine/bin/./dsjob -server setlap1 -user dsadm -password icek8tul -run -jobstatus DEV_GE STTUS_CONTROL ERROR: Failed to open project Stat...

Hi All, We are running Jobs on 8.5 We recently moved our code to New Test box and the project name is Test_GE . We dont have any issues while opening the project Or Runinng the Jobs in the project from Director But while running the jobs from the Command prompt we are getting the following error mes...

Hi All, We are using Db2 Connector stage to load into our Database As a part of requirement we have added reject link to the Db2 Connector stage. In the Stage properties , we have used the following properties 1. Record Count = 0 2. Array Size =1 In the Properties of Reject link,we mentioned to abor...

Hi Chullet,

Db2 API stage is not allowing reject link to declaare

please advise

Regards