Search found 45 matches

by karthikgk0705
Wed Nov 15, 2006 12:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing parallel canvass in standalone system
Replies: 6
Views: 1825

Installing parallel canvass in standalone system

Hi, I am new to DS.Can anybody suggest how to install PEX in standalone system? I heard from my friend that if only unix is installed I can work in PEX, I have done it even then its not working. Plz dont tell that this has been already answered as I have searched for. Thanks in advance. Thanks, Kart...
by karthikgk0705
Mon Nov 13, 2006 9:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: invalid job handle
Replies: 2
Views: 2247

Re: invalid job handle

sirs, when i run a sequence. it gets aborted by saying (controller problem invalid job handle) :( .can u help me to figure out the problem.the sequence consist of reconcilation job runs seven times with dfferent invocation _id.. thanks in advance Do you have any Job control routines attached to thi...
by karthikgk0705
Tue Sep 05, 2006 11:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to call an oracle sequence in transformer stage?
Replies: 2
Views: 1711

How to call an oracle sequence in transformer stage?

Hi All,
Can anyone clarify me regarding how to call a sequence(created in pl/sql) in server job transformer stage?

Thanks in advance
by karthikgk0705
Tue Sep 05, 2006 8:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Incremental Loading in DS
Replies: 3
Views: 1593

Incremental Loading in DS

Hi All,

How to do incremental loading in datastage in server jobs?
Is there any difference in loading in server and parallel jobs?
Is there any relationship between incremental loading and scheduling?
by karthikgk0705
Tue Sep 05, 2006 8:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence in DS
Replies: 3
Views: 3151

Sequence in DS

Hi All,

Pls clarify me regarding how to call an oracle sequence inside the data stage?
by karthikgk0705
Mon Sep 04, 2006 11:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to generate surrogete key in server jobs?
Replies: 2
Views: 2322

Yah I got it.
Thanks rasi....
by karthikgk0705
Mon Sep 04, 2006 11:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to get the latest record from dimension table?
Replies: 2
Views: 2971

how to get the latest record from dimension table?

Hi all, I have a scenario which goes like this. i have a dimension table named 'customer' with columns customer id,customer name and address. If a particular customer say A,keeps changing his address,how do i bring in those changes in my customer table. Conditions are that all the previous addresses...
by karthikgk0705
Mon Sep 04, 2006 11:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to generate surrogete key in server jobs?
Replies: 3
Views: 2488

how to generate surrogete key in server jobs?

Hi,
How to generate surrogate key in server jobs?which functions shd I use?

Thanks.
by karthikgk0705
Mon Sep 04, 2006 11:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SCD in datastage-how to implement?
Replies: 2
Views: 2107

SCD in datastage-how to implement?

Hi all,
I know the basic concepts about Slowly Changing Dimensions.But I get into trouble when I try to put them in real-time in data stage?

Can anyone clearly explain me how to implement SCD in data stage?
(for all three types).

Thank u
by karthikgk0705
Mon Sep 04, 2006 11:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to work on PEx in stand-alone machine?
Replies: 2
Views: 2540

How to work on PEx in stand-alone machine?

Hi all, I have installed data stage enterprise edition in my PC. And my OS is Win XP.And I have linux too as my 2nd OS. I dont face any problem in working with server jobs. But when try to design paralle job,I'm not able to compile or run. What shd I do to overcome this problem? Also I'm not able to...
by karthikgk0705
Mon Sep 04, 2006 11:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SCD in datastage-how to implement?
Replies: 2
Views: 1718

SCD in datastage-how to implement?

Hi all,
I know the basic concepts about Slowly Changing Dimensions.But I get into trouble when I try to put them in real-time in data stage?

Can anyone clearly explain me how to implement SCD in data stage?
(for all three types).

Thank u
by karthikgk0705
Mon Sep 04, 2006 11:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to generate surrogete key in server jobs?
Replies: 2
Views: 2322

how to generate surrogete key in server jobs?

Hi,
How to generate surrogete key in server jobs?which functions shd I use?

Thanks.
by karthikgk0705
Mon Sep 04, 2006 11:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to get the latest record from dimension table?
Replies: 3
Views: 2941

how to get the latest record from dimension table?

Hi all, I have a scenario which goes like this. i have a dimension table named 'customer' with columns customer id,customer name and address. If a particular customer say A,keeps changing his address,how do i bring in those changes in my customer table. Conditions are that all the previous addresses...
by karthikgk0705
Mon Sep 04, 2006 11:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: stored procedures vs plug -ins
Replies: 1
Views: 809

stored procedures vs plug -ins

Hi,
Can u pls clarify me regarding the differences b/w stored procedures and plug-ins?which one is more favourable?why do we have two such entities?

Thanks in advance
by karthikgk0705
Mon Sep 04, 2006 10:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: routines vs transformations
Replies: 1
Views: 971

routines vs transformations

Hi,
Can anyone tell me the exact differences b/w routines and transformers?what are all the difference between them?
thanks in advance