Search found 48 matches

by fareeda_b
Wed Dec 03, 2008 4:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove duplicates using Transformer
Replies: 8
Views: 5824

Need clarification in Transformer

Hi Deepak, In sort stage will have key change column right but we don't have option as key change=1 in transformer so how will remove dupilcates in transformer . my logic is take 3 stagevaraibles st1 =st3 st2= if stg1=stg3 then duplictae else Not-duplicate st3= column name if i'm wrong this please c...
by fareeda_b
Wed Dec 03, 2008 3:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job creation date
Replies: 2
Views: 1111

job creation date

Hi All,

I want to see the job creation date. How can I see it? Is there any command for that?



thanks
fareeda
by fareeda_b
Mon Dec 01, 2008 5:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage PX Log File
Replies: 2
Views: 1005

DataStage PX Log File

hi all, I came to know from the log file that one of the Data Stage PX jobs is in Finished (see Log) status. When I opened the log entries, I could see that Fatal Messages are being displayed along with the Successful completion of the job status in the same log file. Is it possible to have a log wi...
by fareeda_b
Mon Dec 01, 2008 5:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: which version of ds parallel extender is support the window?
Replies: 3
Views: 1583

which version of dS Parallel extender is support windows?

Hi all,

Which version of datastage(parallel job) is support the window platform(windows xp , professional) to install on local pc right? .


Thanks
fareeda
by fareeda_b
Mon Dec 01, 2008 2:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS server installation running on windows Advanced Server
Replies: 2
Views: 959

DS server installation running on windows Advanced Server

Hi all,

Datastage server installation running on windows Advanced Server.


thanks
fareeda
by fareeda_b
Mon Dec 01, 2008 2:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: which version of ds parallel extender is support the window?
Replies: 3
Views: 1583

which version of ds parallel extender is support the window?

Hi all,

which version of ds parallel extender is support the window?


Thanks in advance
fareeda
by fareeda_b
Mon Nov 17, 2008 6:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Function in Datastage
Replies: 2
Views: 3464

Date Function in Datastage

Hi All,

how to add one month to current date() in datastage?

thanks in advance
fareeda
by fareeda_b
Wed Nov 12, 2008 6:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: handling special characters
Replies: 3
Views: 1813

hi

Hi ,
As of my knowledge u can use string function 2 remove special characters in Query

Select substr(columnname,2,len(columnname) from tablename;

try this it will help you to remove special characters in query

if u want to remove in DS use convert function

thanks
fareeda
by fareeda_b
Thu Sep 11, 2008 2:45 am
Forum: General
Topic: DS Server installation running on windows Advanced Server?
Replies: 1
Views: 960

DS Server installation running on windows Advanced Server?

HI All,


Datastage Server installation running on windows Advanced server?


thanks
fareeda
by fareeda_b
Thu Sep 11, 2008 2:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Trimming the field
Replies: 9
Views: 3024

Need explanation on Downcase () and Upcase ()

HI SujathaK,

Could you please give me xplanation how you used the Downcase () and Upcase () to resolved ur problem?

thanks in advance
fareeda
by fareeda_b
Thu Sep 11, 2008 2:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Trimming the field
Replies: 9
Views: 3024

Need explanation on Downcase () and Upcase ()

HI SujathaK,

Could you please give me xplanation how you used the Downcase () and Upcase () to resolved ur problem?

thanks in advance
fareeda
by fareeda_b
Wed Sep 10, 2008 2:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compare the rows in data stage?
Replies: 7
Views: 8503

Compare the rows in data stage?

HI ,

How to compare the rows in data stage?


thanks in advance
fareeda
by fareeda_b
Wed Apr 09, 2008 4:27 am
Forum: Site/Forum
Topic: How do u identify from the link marker icons
Replies: 1
Views: 2841

How do u identify from the link marker icons

HI ,

How do u identify from the link marker icons, which stages execute in parallel and which stages execute in sequential mode?


Thanks
Fareeda
by fareeda_b
Wed Apr 09, 2008 4:25 am
Forum: Site/Forum
Topic: How will you come to know whether its a SMP system or MPP
Replies: 1
Views: 2824

How will you come to know whether its a SMP system or MPP

HI ,

How will you come to know whether its a SMP system or MPP system by looking at the configuration file??


Thanks
Fareeda
by fareeda_b
Wed Feb 27, 2008 10:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Why we preffere Surrogate key than the primary key
Replies: 6
Views: 2862

Why we preffere Surrogate key than the primary key

we are maintaining the history in type2. for primary key value we are using surrogate key.

but in one interview he asked why u preferred surrogate key than the primary key and tellme the what is the difference b/w Surrogate key and primary key