DSXchange

Hi All, This is a simple question and I need to figure out the best way. I have input records. For each record I need to process it using almost 20 different kind of procedures. Then need to produce output have sequential number 1 to 20. and same for the next one. So for hundred input records I will...

Hi All, I m here to define the problem in detail. We have two address input. But one address to copied 3 times and the second one is copied 2 times in a target. All address belong to same person. Now for two address we have output table having 5 serial number for address. In next table we are again ...

Hi All,

Thanks for all the replies. The only problem is that, there is no defined rules for the record. It depends on its serial no. We used store procedure and it works fine.

Thanks again.

Sylvan_rydes

Hi All, I have this problem as described below- I have input records as below: P Q (P and Q are column names) 1. A 2. B 3. C 4. D 5. E 6. F Now I need output like W X Y Z (W, X, Y and Z are column names) 1. A B C 2. D E 3. F .. Any help will be appreciated. Thanks in advance. Sylvan Rydes

Hi All,

I am using the above routine for my job. But I can't use it for more than one entity. It causes problems. I need to store almost 5 entities this way.

Or I need to use something else. Any help will be appreciated.

Thanks in advance.

Sylvan Rydes

Hi Craig,

Thanks a lot for helping me out again. I have tried the same thing but din know how to get priority thing done. But now I understand that it is just upper and lower case.

Thanks again.

Sylvan

Hi All,

This is for knowledge and work support as well. I have two columns and I need to sort with respect to both. But the first column has priority so the second one gets sorted based on first one.

It would be great if someone could explain in detail. Thanks in advance.

Sylvan

Hi Craig,

Thank a lot for the reply.

Sylvan

Hi All, This is something new for me. I have an ETL job with some value added processing. Here I need to use the values of current record to define some columns of next record. I don know how to keep track for the entries in previous record. Any help would be appreciated. Thanks in advance. Sylvan

Thanks a lot

Hi everyone,

This is one simple and silly question. I am trying to generate a random string with random number of alphabates. I have the max legth of string. But I don know how to generate random string. I know that Rnd can be used but how?

Thanks in advance.

Sylvan

Thanks for reply. I even changed the default 8 before but still got the same result. I will try something else coz this thing was working before.

Thanks again.

I have been trying to import table definition for COBOL file layout through manager. I was succenssful all the time. But this time even though the extract looks good but still I get this error : 01 level is not found. Even though the file has 01 level. I am giving you the sample here. http://i78.pho...

Hi Craig,

Well...I know that. I just want to know that how can DS help us to do the same thing as version control does.

Thanks for your reply.

Sylvan

Hi All,

Can anyone tell me how can datastage help to do version control.

Thanks.
Sylvan