DSXchange

Hi, There is a "TimestampFromDateTime function in the parallel extender.. Its available in the "DateandTime" set of options in a parallel transformer. Regards, The Bird Hi All, Can any one of you let me know how to convert the datetime to timestamp in parallel extender jobs. Thanks in...

Hi Sandeep, There is a Column Export and a Column Import Stage in the Parallel Edition. You should be able to do what you want, with these stages. The help files for these stages should assist you well, for this purpose. Regards, The Bird. Hi i am creating a job for history processing , and i need t...

Hi Roy, Got the issue resolved. It was because I had given the Record Delimiter as a UNIX newline, and the source file was not a unix file. My 505th character is a quote and that is where the record ends. Thnx for a quick response. Regards, The Bird. Hi, Have you got a 505 characters limit for the r...

Hi, I am running a job which reads data from a sequential file and then after processing loads a dataset. The job does run to completion, but throws a warning which says : InputSfSrc,0: Import consumed only 505bytes of the record's 506 bytes (no further warnings will be generated from this partition...

Prashant, If you leave the field length for this particular field empty, when defining it as a varchar in the sequential file, you problem should be solved. This happens when a numeric field is defined for a particular length in a comma delimited file, and while trying to read the data, the delimite...

Hi Amit, Had faced the same problem a few days back. This is a memory related issue. You are running out of memory !!! Have you allocated enough space in the configuration file for your job?? Try running your job after removing certain stages!!! For example trying to remove certain sort stage, trans...

Hi,

You can use the IsValid function for the date validation purpose. It would return 1 if valid and 0 if invalid.

The syntax would be -

IsValid("date",in.date)


Regards,
THe Bird.

Hi Ray, Correct me if i am wrong, please. As far as columns "appearing from nowhere" are concerned, I believe this happens only when RCP is enabled on stages where certain columns are being dropped, as the RCP carries forward the metadata to the stages appearing downstram. If RCP is disabl...

Hi Ray, Can you explain this a little more. I thought that when you had RCP enabled the linkage to the table definition is not broken unless forcibly done. The "Table Definition Reference" in the columns tab does seem to show the linkage to the table definitions, even when the metadata is ...

Sanjay, You can use a Column importer and a transformer for this purpose. The reject link from the seq file would lead to the column importer where yopu can split the incoming rejected VarBinary row to multiple columns as in the source, but with the datatype as Varchar. And then in the transformer d...

Chulett, What I meant by a generic routine was that it is a routine common across a number of jobs. The routine and the sequence used is generic. They are commonly used across a number of jobs, like a template. The sequence i had mentioned about is a template. But when it is run, it starts off, thro...

Hi, I am trying to run a sequence. But the sequence seems to just to start off and then abort after giving a warning that says, "Job control process (pid 28001) has failed" Can anybody help me by pointing out what this warning might be? I have 2 jobs in the sequence, which are called throu...

Hi, I have a comma delimited source , which is to be loaded to a dataset. I have 4 fields with different telephone numbers coming in, and have to create different entries in the dataset depending upon the number of telephone numbers. If there is only 1 telephone, then 1 entry; if there are 2 telepho...

Hi, I am getting quite few warnings, when i run my job. All warnings are of the same nature and says: "When checking operator, Defaulting <fieldname> in transfer from "inrec" to "outrec" ." The log says that this occurs at a particular Funnel stage. But the funnel doesn...

Hi, Actuallly, the job has validations at different levels ie, : 1. A validation before a column import stage.( the source is in header-detail-trailer format.) I am reading the data as one string and then splitting the columns in the column import stage. 2. Another validation after the columns have ...