DSXchange

Hi Guys Thanks so much for the pointers.We brainstormed in between the team here and thought about different ETL solutions, and finally we came to the conclusion to push all the incoming data directly into the target tables by defining all the target fields as varchar. During consumption of the data...

Hi Experts I have a requirement wherein I have to create a generic job that will read from around 200 different delimited files and then populate data into their corresponding target tables (Netezza).Each file metadata is different and the delimiter can be either pipe,tab or comma. The other require...

We faced the same error recently. Upon analysis, we couldn't find anything concrete so a PMR was raised with IBM. IBM confirmed that the issue is related to Operating System(windows). As of now we are still awaiting their further response and resolution. For reference, below is the error we were get...

RCP,Propogate Values property,Multi Instance property,looping in transformer,range lookup.

Version - 9.1

If there are NULL values in the source column and if it is being TRIM'ed - it throws an error. Try removing the TRIM function and check once.

What is the error that you are getting?

Note - In the Execute Command Activity, prefix powershell.exe before executing your script.

For example, if you want to execute script namely "abcd.ps" then in the command activity put up the following :-

powershell.exe abcd.ps

DateOffsetByComponents(%basedate%,%yearoffset%,%monthoffset%,%dayoffset%) can do the trick for you

You can take count of records from the source file and use a filter stage to determine if the count is 1 or greater than 1, in such a case update the data in the table and in the after SQL , insert the file data into the table

1.First job will dump the EMP_ID data from the table to a sequential file 2.Take the count of records from the sequential file into a user variable 3.Start a loop, initialize it to run on the count variable value 4.Use sed command (in a command activity) to get the first record from the sequential f...

First use convert/ereplace for "/" to "-" conversion,then use StringToTimestamp (In case you are reading from a varchar column) with following setting - %yyyy-%mm-%dd %H:%n:%s %aa

Is the code 141 or -141?

For -141, the reason could be "Failed to log to UV account"

By any chance is the job being invoked from a sequence and in turn the sequence is the one that is scheduled?

You can try renaming the job and verifying if there is any process that is now failing since it is not able to find the real job to execute.

There are unreadable/special characters in your input data.Analyse such data and use correct NLS setting to process it.

You are replacing NULL with some value that is within quotes. Check if the LOC column is a varchar column , also check if the following works fine or not.

NVL(LOC,1) AS LOC
COALESCE(LOC,1) AS LOC
COALESCE(LOC,'-1111') AS LOC

Check how many jobs are running (It is possible that at a given time if many jobs are executed, then they might run out of resources)
Check if job is in aborted/crashed/not compiled state