Search found 107 matches

by ntr
Mon Sep 25, 2017 12:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage error
Replies: 1
Views: 2235

Datastage error

Hi,

one job got aborted due to below errors

main_program: APT_PMsectionLeader(8, node8), player 3 - Unexpected termination by Unix signal 31(SIGUSR2).

And failing Insert statement.

Could you please help on this issue.
by ntr
Thu Sep 22, 2016 1:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp Issue
Replies: 3
Views: 2603

Timestamp Issue

Hi All, Could you please help on below issue. I am using 8.7 Data stage version I have one column like Effective_DateTime This column I am getting source and same column I need to mapped to Target In Source I am getting Effective_DateTime like 21/09/16 12:00:00 But my requirement is I need to popula...
by ntr
Thu Jul 14, 2016 11:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Record loaded issue
Replies: 6
Views: 4114

Record loaded issue

HI, Could you please help on below issue. I am using 8.7 Data stage version I have created one data stage job and Job finished successfully and in Data stage director also showing data loaded in to target table but when I check the DB level Target table I am getting the Records count 0 only. But my ...
by ntr
Sun Dec 13, 2015 10:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file in server version
Replies: 8
Views: 7182

Hi qt_ky/chulett,

Thanks a lot for your valuable information.
by ntr
Thu Dec 10, 2015 10:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file in server version
Replies: 8
Views: 7182

HI,

I am getting below error

(40813) THE DESTINATION STAGE CANNOT SUPPORT ANY MORE STREAM INPUT LINKS
by ntr
Thu Dec 10, 2015 10:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file in server version
Replies: 8
Views: 7182

HI Thanks for your replay I can able to give the all the links like ( source link, target link ) But I am not able to give the reference link from Hashed file to Transformer Stage. My Job like below: Seqfile -----Hash file Seqfile---Transformer---------Target Could you please help on this. Br, ntr
by ntr
Thu Dec 10, 2015 7:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file in server version
Replies: 8
Views: 7182

Hash file in server version

Hi Team Could you please help on below issue I am using Data stage 11.3 version and server jobs I have to perform look up condition in server jobs for that, I am using Hash file in server version My job like below: Seqfile -----Hash file Seqfile---Transformer---------Target Here I am not able to g...
by ntr
Tue Oct 13, 2015 11:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file
Replies: 2
Views: 5168

Hashed file

Hi All , Could you please help on below quation We are using OPTIM tool insisted of Data stage My question is : In data stage we are extract the files right like that I want to extract the data from Hash file is it possible ? As I know Hash file is used for reference only. but how we can extract the...
by ntr
Sat Sep 22, 2012 11:52 am
Forum: General
Topic: Set limit for warnings for a datastage job without director
Replies: 4
Views: 3419

warning limit without director

Hey i am using 8.1 parallel edition,in my project i want to set warning limit for every sequence,when we use warning limit option in director or designer it would give the results for current session.i want to do it automatically at job or sequence level.
by ntr
Fri Sep 21, 2012 9:12 am
Forum: General
Topic: Set limit for warnings for a datastage job without director
Replies: 4
Views: 3419

Set limit for warnings for a datastage job without director

i want to set the warning limit for a job.My requirement is when ever we will get more than 5 warnings job would be aborted automatically.
it would possible by Routine or global parameter?
by ntr
Thu Sep 20, 2012 1:25 pm
Forum: General
Topic: JOB ID In datastage
Replies: 7
Views: 8784

Thanks for your repaly...
by ntr
Thu Sep 20, 2012 1:07 pm
Forum: General
Topic: JOB ID In datastage
Replies: 7
Views: 8784

Small confusion Please help me JOB ID and JOB NO Same ?
by ntr
Thu Sep 20, 2012 12:50 pm
Forum: General
Topic: JOB ID In datastage
Replies: 7
Views: 8784

JOB ID In datastage

Hi ,

Please help me where i need to check Job id ..


Regards,
ntr
by ntr
Thu Aug 30, 2012 1:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD
Replies: 5
Views: 2602

Thanks SURA for reply In first step i had given output linkname in second step i added purpuse code for all columns and did lookup with BUSSINESS key column in third step i had given surrogate key file which was created by surrogate key stage in fourth step mapped the columns into derivation and sta...
by ntr
Thu Aug 30, 2012 1:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD
Replies: 5
Views: 2602

Can any body please


Thanks