DSXchange

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...

Hi All,

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



thanks
fareeda

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...

Hi all,

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


Thanks
fareeda

Hi all,

Datastage server installation running on windows Advanced Server.


thanks
fareeda

Hi all,

which version of ds parallel extender is support the window?


Thanks in advance
fareeda

Hi All,

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

thanks in advance
fareeda

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

HI All,


Datastage Server installation running on windows Advanced server?


thanks
fareeda

HI SujathaK,

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

thanks in advance
fareeda

HI SujathaK,

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

thanks in advance
fareeda

HI ,

How to compare the rows in data stage?


thanks in advance
fareeda

HI ,

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


Thanks
Fareeda

HI ,

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


Thanks
Fareeda

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