Search found 3 matches

by johnsk
Thu Feb 16, 2012 9:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multi-Load stage may be for timestamp column - Error
Replies: 0
Views: 925

Multi-Load stage may be for timestamp column - Error

Hi DS-Masters, I am getting following error in Multi-Load stage for timestamp column (may be issue is with timestamp column (ABC) also tried in DS - Varchar datatype for Teradata database - table column (ABC) Timestamp) i search in post in DS 7.5 but was unable to find any post on this error. I am d...
by johnsk
Tue Aug 11, 2009 1:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SCD type 2 in server jobs in DS 7.1....Need help
Replies: 3
Views: 3056

I have resolved this longtime back but forgot to mention in DSXchange, i used some workaround my self and resolved it. I created to 2 jobs, 1. 1st job loads data from table 'A' (Ora stage) with max seq no. of each pol no. in hash file. (First run table would be empy) 2. 2nd job uses SRc file does a ...
by johnsk
Sun Jul 19, 2009 2:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SCD type 2 in server jobs in DS 7.1....Need help
Replies: 3
Views: 3056

SCD type 2 in server jobs in DS 7.1....Need help

Hi, I need help to implement like SCD type 2 in Server jobs DS 7.1, n i have two columns in source.... pol no. and seq no., but "seq no." is not populating properly current in source...so need to correct it... Source data example, First run, pol no. | seq no. | 171 | 1 | 171 | 4 | 171 | 5 ...