Hi All,
Can anyone guide to avoid this warning, apart from using 'message handler'
Lookup_15,0: Ignoring duplicate entry at table record 1; no further warnings will be issued for this table
Regards
Suresh
Search found 17 matches
- Tue Aug 09, 2011 12:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to avoid Lookup Warning
- Replies: 2
- Views: 2696
- Thu Apr 28, 2011 7:12 pm
- Forum: General
- Topic: Clear PH directory through a job
- Replies: 3
- Views: 2663
Re: Clear PH directory through a job
Hi,
write script which calls uvsh clear.file &PH&
call this script using the command activity in sequence after successfull execution of job
Regards
Suresh
write script which calls uvsh clear.file &PH&
call this script using the command activity in sequence after successfull execution of job
Regards
Suresh
- Thu Apr 28, 2011 6:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Address nameless columns in Hashed files
- Replies: 11
- Views: 4607
Re: Address nameless columns in Hashed files
Hi,
delete the hash file with delete.file <File Name> then recreate and populate the data and then try to update the hash file.
Regards
Suresh
delete the hash file with delete.file <File Name> then recreate and populate the data and then try to update the hash file.
Regards
Suresh
- Thu Apr 28, 2011 6:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: fatal Error
- Replies: 3
- Views: 4701
Re: fatal Error
Hi,
Please check in the database for the object 'DL0053_In_SDD_Adjustment_H', table is not present in the databse.
Regards
Suresh
Please check in the database for the object 'DL0053_In_SDD_Adjustment_H', table is not present in the databse.
Regards
Suresh
- Tue Apr 12, 2011 6:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise : Fatal Error: Invalid open command
- Replies: 1
- Views: 2396
Oracle Enterprise : Fatal Error: Invalid open command
Hi, I have requirement to truncate data and drop index before loading data into one of the oracle table. I used Oracle Enterprise stage and given to statements in open command (first i tried both statements seperated by semicolon, and also without semicolon) but fot the error Oracle_Enterprise_24,1:...
- Tue Mar 29, 2011 11:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Clearing Datastage Log RT_LOGnnn based on the no of runs
- Replies: 1
- Views: 2578
Clearing Datastage Log RT_LOGnnn based on the no of runs
Hi,
I want to clear the datastage log based on days or number of runs through the script.
$DSHOME/bin/uvsh 'CLEAR.FILE RT_LOG'$JobNo - This clears everthing from the log file, i want to clear based on the no of days or no of runs
Can anyone help on this.
Regards
Suresh Angadi
I want to clear the datastage log based on days or number of runs through the script.
$DSHOME/bin/uvsh 'CLEAR.FILE RT_LOG'$JobNo - This clears everthing from the log file, i want to clear based on the no of days or no of runs
Can anyone help on this.
Regards
Suresh Angadi
- Tue Mar 29, 2011 7:05 pm
- Forum: General
- Topic: Auto Purge Log Project Property Change in Production
- Replies: 4
- Views: 2613
Auto Purge Log Project Property Change in Production
Hi, I need one clarification about Auto Purge Log project propery, I have some 2000 jobs running daily in production and some jobs run with multipule instance (Same invocation id is used for every run so logs keep on appending). Auto purge Propery was set to 40 days. I want to change Auto Purge Prop...
- Thu Mar 24, 2011 12:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Break in the sequence numbers
- Replies: 6
- Views: 8073
Re: Break in the sequence numbers
Hi Prasad,
@PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1
((@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1)
both the formula for getting seq no works fine, i think some logic problem in your job.
can you explain what is your datastage job logic.
Regards
Suresh
@PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1
((@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1)
both the formula for getting seq no works fine, i think some logic problem in your job.
can you explain what is your datastage job logic.
Regards
Suresh
- Wed Mar 23, 2011 10:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS IMPORT FAILED IN DATASTAGE 8.1 USING IMPORT
- Replies: 2
- Views: 3870
Re: DS IMPORT FAILED IN DATASTAGE 8.1 USING IMPORT
Hi Srikanth, I also tried using the dsjob -import command and i dont think release 8.1 supports this, i got the fallowing message [sys0ctm@etlat1:/data/sdw0/sys/sys0/Projects]> dsjob -import dsjob -import is not supported at this release. I am using the IIS server release 8.1 Regards Suresh Angadi
- Sun Jul 19, 2009 8:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing inputs to a SP Stage from another stage
- Replies: 4
- Views: 2182
Re: Passing inputs to a SP Stage from another stage
Hi Harsh, you can use the custom SQL along with parametrization and use the arry size as 1000 and transaction size to 10000. Regards Suresh Hey, I'm working on huge sets of data and to load the entire table from the source does not makes sense. I can write a query to get the required records only bu...
- Sun Jul 19, 2009 8:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing inputs to a SP Stage from another stage
- Replies: 4
- Views: 2182
Re: Passing inputs to a SP Stage from another stage
Hi Harsh, you can use the custom SQL along with parametrization and use the arry size as 1000 and transaction size to 10000. Regards Suresh Hey, I'm working on huge sets of data and to load the entire table from the source does not makes sense. I can write a query to get the required records only bu...
- Sun Jul 19, 2009 8:24 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: 3053
Re: SCD type 2 in server jobs in DS 7.1....Need help
Hi Jhon, user CRC32() function to identify the change in the source and then you can use any of the scd-type 2 that is timestamp or versioning. Regards Suresh 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....
- Wed Jul 15, 2009 11:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage 7.5.3 Running on Windows 2000
- Replies: 1
- Views: 1277
Re: Datastage 7.5.3 Running on Windows 2000
Hi, yep, you can run DataStage Server 7.5.3 on win 2000, before datastage installation you need to instal service pack 2 or latest. Regards Suresh R Angadi Does anyone know if DataStage Server 7.5.3 will run on a Windows Server 2000 machine? Yes, I know the reccommended minimum spec is Windows 2003,...
- Wed Jul 15, 2009 6:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error:No conductor nodes found in export node pool
- Replies: 5
- Views: 7251
Re: Error:No conductor nodes found in export node pool
Hi Sridhar, whenever you are reading from file or writing to file you need to user the two environemnt variables called APT_GRID_SEQFILE_HOST and APT_GRID_SEQFILE_HOST2 which runs on conductor node, so use APT_GRID_SEQFILE_HOST2 on the file name before the file path name. Regards Suresh R Angadi Hi,...
- Tue Jul 14, 2009 12:32 am
- Forum: General
- Topic: Looping in DataStage Jobs
- Replies: 11
- Views: 4975
Re: Looping in DataStage Jobs
hi, you can implement that loop condition with if else condition along with the logical operators in transformer stage. if else condition for both input data and reference data. Regards Suresh Hi ! I have x number of conditions that I need to check. And if first condition passes, I don't need to go ...