Search found 29 matches

by ReachKumar
Tue Mar 30, 2010 8:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Shared Container
Replies: 10
Views: 5004

yes i mean input links
by ReachKumar
Tue Mar 30, 2010 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Shared Container
Replies: 10
Views: 5004

Can shared container has two input files?
by ReachKumar
Tue Mar 30, 2010 6:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Shared Container
Replies: 10
Views: 5004

Hi, I have a set of jobs. All the jobs has the input field(Say Emp_ID). Each job creates one output file with some logic(Hope it wont be necessary now) Now my requirement : Before the output stage, i need to lookup the input data with the common file(Which will be common across all the jobs) based o...
by ReachKumar
Tue Mar 30, 2010 1:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Shared Container
Replies: 10
Views: 5004

Shared Container

Hi,

How to create and use shared containers in the job?

Please help.
by ReachKumar
Thu Mar 25, 2010 12:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clarification on Pivot Stage
Replies: 4
Views: 2504

I am not able to view the entire data.

Anyways I understand the logic.

Thank you so much for the clarification Ray.
by ReachKumar
Wed Mar 24, 2010 12:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Details of Node and Pool in the configuration File
Replies: 4
Views: 2990

Thanks asorrell .

One more clarification:
If pool is nothing but grouping resources like disk pool then what is resouce disk and scratch disk.

Is disk pool same as resouce disk and scratch disk?
Please explain
by ReachKumar
Tue Mar 23, 2010 8:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Details of Node and Pool in the configuration File
Replies: 4
Views: 2990

Details of Node and Pool in the configuration File

Hi,

Can some one explain the terms Node, Pool and the relationship between Nodes and Pools in the Datas=Stage configuration file?
by ReachKumar
Thu Mar 18, 2010 4:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Route one of Duplicates based on condition
Replies: 9
Views: 5693

To compare and drop the remaining records in transformer, the records should be sorted.

If the data is sorted already, then i think you can also use Remove duplicates Stage to retain first record based on key column(First column in your case).
by ReachKumar
Wed Mar 17, 2010 6:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Selection of Lookup and Join
Replies: 2
Views: 1982

Informative.. Thanks Suraj..
by ReachKumar
Wed Mar 17, 2010 5:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Selection of Lookup and Join
Replies: 2
Views: 1982

Selection of Lookup and Join

Hi,

Performance wise, which one is better to go for between Join and Lookup stage in DS Parallel and why.

Can some one explain in which scenarios we go for join and for lookup?
by ReachKumar
Tue Mar 09, 2010 3:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Significance of jobid
Replies: 3
Views: 2215

Significance of jobid

Hi,

When i executed the command : "dsjob -jobid nxg_symm PivotPrac" (Here - nxg_symm is project name and PivotPrac is the job name),
i got the following message,

Status code = 0

What does it mean and what is the significance of -jobid.Can some one explain me please?
by ReachKumar
Tue Mar 09, 2010 3:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clarification on Pivot Stage
Replies: 4
Views: 2504

Hi Ray,

Thanks for the reply.
Can you explain in more detial.
by ReachKumar
Tue Mar 09, 2010 12:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clarification on Pivot Stage
Replies: 4
Views: 2504

Clarification on Pivot Stage

Hi, I thought Pivot stage is used to convert Columns into Rows. INPUT: ------ ID : 1 NAME : ONE AGE : 10 RATTING : 100 Derivation for the First column : ID,NAME Derivation for the Second column : NAME,AGE,RATTING OUTPUT: ------- "1","ONE" "ONE","10" "&quo...
by ReachKumar
Wed Mar 03, 2010 1:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Merge Stage using Two Sequential Files
Replies: 9
Views: 4887

Adding one more point to the above post :

You can do as gssr told.