DSXchange

I used a sequence job to count the lines in output file. Then added 100 to the count each time. This added value is passed to the HEAD-STAGE in parallel job as parameter. The sequence job as: EXEC_COMMAND --> JOB_ACTIVITY The parallel job as: SEQ_FILE --> HEAD-STAGE --> TAIL_STAGE --->SEQ_FILE HEAD-...

Thanks suja.somu
It worked. The only problem is, I read the input fixed width data as Varchar ,so the job aborted. Then i replaced it with Char datatype and the problem resolved :D

Hi I have a fixed width file with header record and detail record. Header record layout is different from that of detail record. For example, I have the data: 00Employee_Details2013-05-242 -------------->HeaderRecord 012012-01-01Ram29842013-05-24 23:23:45 --------------->Detail Records 012012-02-02S...

Sorry chullet for posting my work requirement. I hardly have any idea of converting sequential file into xml, as i am a newbie to DS .Thought that this forum will provide ideas for the same. I shall browse through other similar topics pertaining to my work before posting.

I tried to pass the Invocation Id value as Job Parameter. In the "Default Value" of the Parameters , i gave the macro "DsJobInvocation Id".But the Job Aborted. Any ideas for the same?

I tried to write routine to load data of each record to seperate file, with the name of the respective record. But found it very difficult. Kindly appreciate if anyone could provide any tutorial link for routines. Thanks for the reply ray and chullet.

I tried splitting the files with sequence job. If my input file name is john,and if i split my files to 4,the resultant files are named as "johnaa","johnab" "johnac"," "johnad" .After splitting the files, a parallel job loads each splitted file per execut...

To generate output xml file i/p ip_finename.txt dob_year,dob_month,dob_date,name,emp_no 1985,10,05,Kannan,1000 1985,10,05,ram,1001 1985,10,05,a,1002 1985,10,05,b,1003 . . . 10 records o/p file generation condition: the o/p xml shold contain only 4 employee details per xml, so here 10 i/p records wil...

To Create a job to generate the output file name with the data from input file for each record.

Ex: Input File

dob_year,dob_month,dob_date,name
1985,10,05,Kannan
1986,11,05,Kumar

Output file name should be:
Employee_Kannan_1985-10-05.txt

Thanks for the reply chullet. Yes,it seems like an odd requirement. I am a datastage trainee in my company.My lead gave this scenario to test my design capability.

I am having 1000 records in a file but i need to load 100 records per execution.After the first execution,need to process second 100 records.etc...Upto 1000

Hi

I have a row with data as follows

abc|xyz|a,b,c,d|123

I need the demiter comma to be replaced by Pipe as follows


abc|xyz|a|b|c|d|123 :D