DSXchange

Its always good to update the post with resolution. And so don't you wish to mark the post as resolved?

What is the value that is getting loaded into table for the column HIREDATE?
You can find this in director or for checking, you can replace the database stage as sequential stage and check the output.

When you are running all the jobs in Sequence, the jobs might not be in runnable stare, either running or not compiled. But can you tell us, what are you trying to do in Executecomand activity?

Try to maintain the length of the COLUMN_NM_1, COLUMN_NM_2 as it is in the DB2 source. You can try the truncation and the transformation in second transformer. COLUMN_NM_3 is nullable Yes in the source. Mark default null value in Dataset or NullToValue in transformer. Untill then, the datatype shuld...

Metadata specified does not match to the given file layout. Check for UPDATE_DATE, for which it is complaining about. It has the values in the pattern of mm/dd/yyyy. What is the data type that been specified?
If you cannot nail down, change it to varchar and view the data.

Make sure you dont find any issues in loading Null as date field in DB2. Keep your field as Nullable. You may see some '********.....' as values. Or you can use NullToValue and give some defaults.

All most all functions that you choose from transformer will have % to indicate to pass parameters. You need to pass Column name or any String within qoutes as input.

Quick hint, Make sure you dont get this error in any other jobs.
If this job is the only issue, Create a copy of the same job and try to compile. If that works, you can delete the existing job.
If that doesn't work, take a backup of METL_DEV_R1 and start searching the forum.

If its a delimited file, first count number of delimiter using either DCOUNT or other functions available. If it the number of fields is as expected, do a lookup against production file. If all the fields matches, marks the flag as 'Y'.

Why not a routine that reads the file and set the value as Userstatus for that stage and pass as a parameter to the Looping stage. Alternatively you can read the file using Executecomand activity and pass it as an command output.

Hi Saama, Pivot stage by itself doesn't care about relationships between fields. As an ETL user you should take care of the given business rules to accomplish the task. If you have multiple PAYEMENT LOCATION fields as PAYEMENT LOCATION1, PAYEMENT LOCATION2...for a same customer (CUSTOMER ID), the pi...

Hi Yamini, What is the desing of your JobSequence? Do you have any before Job subroutine or any scripts that been called. How many parallel jobs/JobSequence been called during the run? How busy was your server during the time of this jobsequence been triggered? How many stages in the Job that been c...

Hi Vijay, The best approach is open the pdf to find the syntax and format of each functions that you use. So that you get to know about each functions that you start to use and you will start to modify the given example to your needs. There should be two argument that need to be passed to Iconv func...

Is it possible to set $UserStatus of job#2 inside job#4 or in sequencer.

Its not possible. But you can set Userstatus of Job 2 in Job2 and access it in Job4. Unless you have a Sequencer in between Job2 and Job4.

You might be getting other informative error following to this one. Pls specify that. Or you can search to get to know more.