Search found 30 matches
- Tue Oct 03, 2006 8:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: extract data from file different num of fields in each row
- Replies: 22
- Views: 8122
1. Agree with you that there is no need to use Sorter Stage as all the records are being collected into an intermediate file which is then being used as a Source. 2. I should process one file at a time and the file will have one Header and one Trailer record. 3. Platform being used is Windows. So I ...
- Tue Oct 03, 2006 7:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: extract data from file different num of fields in each row
- Replies: 22
- Views: 8122
Ray, Yes I meant Sort stage. I agree with your suggestion about the performance issues if we use a sort stage, but I am very new to data stage and still getting used it and still exploring the options available in DS. I have worked on Informatica so I am using that knowledge to create jobs in data s...
- Tue Oct 03, 2006 6:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: extract data from file different num of fields in each row
- Replies: 22
- Views: 8122
Hi Ray/Shane, I have just finished working on this job. The logic I have followed: 1. Read all the columns in a row as a string into a transformer ( as suggested in the earlier posts by Shane). 2. Use a stage variable to get the Trailer/ Details rec types (the first field in each string record is th...
- Tue Oct 03, 2006 5:07 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: extract data from file different num of fields in each row
- Replies: 22
- Views: 8122
Hi All, There is some more logic to be implemented in this job. 1. Need to check if both Trailer (T) and Header (H) records are present in the file. 2. The Detail (D) records should be processed only if the file consists of both Header and Trailer records. 3. The Trailer will have date, time and ID ...
- Tue Oct 03, 2006 1:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: extract data from file different num of fields in each row
- Replies: 22
- Views: 8122
- Tue Oct 03, 2006 12:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: extract data from file different num of fields in each row
- Replies: 22
- Views: 8122
I think I should have stressed more on the Reading Data from the file than the logic which follows after reading the data. The issue I am facing now is reading data from the file with rows consisting of different number of fields. H -> 7 Fields D -> 4 Fields T -> 8 Fields Please let me know if ther...
- Mon Oct 02, 2006 11:32 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: extract data from file different num of fields in each row
- Replies: 22
- Views: 8122
- Mon Oct 02, 2006 11:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: extract data from file different num of fields in each row
- Replies: 22
- Views: 8122
extract data from file different num of fields in each row
Hi, I have a situation where I have to extract data from a file with rows in the file contain independent set of fields. ex: row1 -> rec_type, id,name,qualification row2 -> rec_type,country,state,place,location row3 -> rec_type,num_of_rows,file_date,file_time Depending the rec_type , I have to load ...
- Thu Sep 28, 2006 4:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unziping file from Windows environment
- Replies: 25
- Views: 12122
- Thu Sep 28, 2006 3:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unziping file from Windows environment
- Replies: 25
- Views: 12122
- Thu Sep 28, 2006 2:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unziping file from Windows environment
- Replies: 25
- Views: 12122
- Wed Sep 27, 2006 10:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unziping file from Windows environment
- Replies: 25
- Views: 12122
- Wed Sep 27, 2006 1:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unziping file from Windows environment
- Replies: 25
- Views: 12122
- Wed Sep 27, 2006 12:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Unziping file from Windows environment
- Replies: 25
- Views: 12122
Hello All, Any idea about this problem??? We are using DataStage version 7.1, O/S: Windows 2000, WinZIP version: 9.0 with command line support. If anyone has ever tried this one, please let me know how to go about this problem. I have tried all the options 1. Calling ExecDOS in before Job Routine by...
- Tue Sep 26, 2006 11:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to remove additional zeros in a record using Transformer
- Replies: 12
- Views: 13684