DSXchange

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

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

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

Hi,

Please check in the database for the object 'DL0053_In_SDD_Adjustment_H', table is not present in the databse.

Regards
Suresh

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

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

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

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

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

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

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

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

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

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

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