Search found 11 matches

by saikat26
Mon Dec 28, 2009 2:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can i generate mixed values in row generator stage.
Replies: 2
Views: 1308

Can i generate mixed values in row generator stage.

Hi, I am having total 2 stage in my job, the first one is row generator where i am generating random data for 2 columns, they are Name and Id. For Name the column size is 20. Everytime i run my job i m getting output like AAAA or BBBB or CCCC,or ssss, but i m not getting output like abcd,erfghuyt, I...
by saikat26
Tue Dec 22, 2009 3:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing . from decimal value.
Replies: 3
Views: 1890

Hi Thanks for replying ..actually my output data is in unix. I am viewing the file using cat filename. There i am seeing .(dot).
by saikat26
Tue Dec 22, 2009 2:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing . from decimal value.
Replies: 3
Views: 1890

Removing . from decimal value.

Hi, In my job i am passing schema file during run-time.In one of the column i have specified as id:decimal[10];. When i see my output data i am getting values like 0000001111. i am getting one extra dot at the end. Can anyone please suggest me why these dot is coming at the end and how can i remove ...
by saikat26
Fri Dec 18, 2009 3:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: i want to pass schema file-name during runtime.
Replies: 5
Views: 2205

I didnt understand clearly ..can you please explain in detail...

Thanks in Advance..
by saikat26
Fri Dec 18, 2009 3:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can i generate specific values in row generator stage.
Replies: 4
Views: 3216

Yes, thanks a lot..i am able to do it...
by saikat26
Fri Dec 18, 2009 2:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: i want to pass schema file-name during runtime.
Replies: 5
Views: 2205

i want to pass schema file-name during runtime.

Hi,

I have a job which uses schema File. My requirement is like that in each and everytime i run my job my schema file name changes.
So can you please tell me how to pass job parameters during time.

Please Help me.
Thanks in Advance...
by saikat26
Fri Dec 18, 2009 2:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can i generate specific values in row generator stage.
Replies: 4
Views: 3216

Can i generate specific values in row generator stage.

Hi ,

Can i generate specific values in row-generator stage while generating raw data.Suppose i have got one column like gender and while generating raw data i want only values "M" or "F" should go into my Output-File.

Please Help me.

Thanks in Advance...
by saikat26
Thu Dec 17, 2009 4:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate Dynamic schema File.
Replies: 2
Views: 1717

Hi Ray,

Thanks a lot for replying..so there is no way we can generate schema file.
Can we make delimiter in the format tab of the sequential file as parameter.
by saikat26
Thu Dec 17, 2009 4:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generate Dynamic schema File.
Replies: 2
Views: 1717

Generate Dynamic schema File.

Hi Guys, I want to generate dynamic schema File from a sequential File. My sequential File is having 4 columns. Which output stage can be used to store the schema File. They are : FIRST_NAME: Varchar(10); MIDDLE_NAME: Varchar(10); LAST_NAME: Varchar(10); GENDER: Varchar(5); Please Can anyone help me...
by saikat26
Sat Oct 24, 2009 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare rule set between two datasets
Replies: 2
Views: 1377

Compare rule set between two datasets

Hi, I have got one dataset which has got total of 36 columns and it is fixed. In the other dataset i have got 36 columns which creates rules of various combinations and which are dyanamic, for example in rules containing dataset coloumns are A1,A2,A3......A36. With different columns set combination ...