DSXchange

what is the purpose of look up? Can some one send me some examples for lookup? If you have a file that contains employee records with the employee State code alone...say FL, and you need the full state name, you can have a reference file with State Code and State Name...FL-->Florida and can lookup ...

Sunshine2323 wrote:As suggested PIVOT stage can get you your required output.

Is this a Parallel job Stage ??

Yes.. the maximum charge bucket in a record is 10. But not necessarily, all 10 charge buckets would be filled in. Is the maximum number of charges on a single input record fixed? If so, how many can there be? If the answer is yes and the maximum number is small you could do it with a single transfor...

Any help on this is appreciated...Please..!! Thanks, V Hi, I have a file with records that carry few occurences[10] of Charges . [1] For each of these input records with charges as an array [1-10], how do I create 10 ouput records with Charge1 in record1, charge2 in record2 and so on. What stage[s] ...

Hello, I'd like any tips or recommendations for running the DataStage client overseas (India, Africa, Asia, etc.). We have some developers in remote locations, who have mentioned slow response working with the DataStage Designer. Just opening a job for editing in Designer can take up to 30 seconds....

Hi, I have a file with records that carry few occurences[10] of Charges . [1] For each of these input records with charges as an array [1-10], how do I create 10 ouput records with Charge1 in record1, charge2 in record2 and so on. What stage[s] is the best ? [2] Again not all input records would car...

This is the problem:- When I tried to add a link to an AGGREGATOR, the link shows up as only Reject link between CFF_Out and Aggregator...Am I missing something here.....Any help is appreciated. Thanks, V I believe you are doing something wrong there try right clicking on the link and convert it to...

Hi, I have a CFF as Input and a Filter to split the CFF input into two CFF's based on two criteria. With CFF_Out1 and CFF_Out2, as input to an AGGREGATOR, I wanted an output that is sum of certain criteria. This is the problem:- When I tried to add a link to an AGGREGATOR, the link shows up as only ...

That's exactly I tried. So would a Filter still write the same input records into 2/more different output records, based on the match criteria ?? :cry: Thanks, V You can try using "Filter Stage" A newbie. 1st hands-on week..need some help.. In this scenario, which is the 'ideal/best' stage...

A newbie. 1st hands-on week..need some help.. In this scenario, which is the 'ideal/best' stage ?? Thanx, V I have input Charge records in this sequence, Rec1: AAAAAA $100 01 02 03 04 Rec2: BBBBBB $150 01 04 07 Rec3: CCCCCC $120 01 03 04 07 and I need to create different output files based on the va...

Yes..This VB file has 4 different record layouts. The file layout is as follows: First few bytes are common across record types and then based on record types, the length varies. I don't exactly remember the 'errors', but can tell you later. -VJ Could you tell us what the "various errors" ...

Hi, I'm using Complex Flat File stage for using a Variable Block COBOL file. I PFTP'ed the file to the DS Server and data looks good. But when I try to View Data, I am hitting a roadblock with various errors. A newbie here :roll: , can anyone just guide me on how to get a COBOL Variable Block file t...

Hi,
Nice to know of this community helping each other out. I'm a newbie and hope I get all the help I might need. Keep up the good work friends.
Vijay

I would also appreciate any useful links,docs that I can refer to, as I'm new to DataStage.