DSXchange

I have a parallel job which gets its data from a Exec command in Sequence job. The output of the Exec cmd (lets say A) is appended to the data in the text file. Delimiter is | . The text file can have 2 records. So A is appended at the end of both the records. The Sequence file in the parallel job w...

Hi All, I have a requirement where in I am getting data in a pipe delimited file which is having data with newline characters in it. Below is the sample content of the data:- 060707394|CUSC|08-JUN-10|77620138|0|11-JUN-10|SOCIAL SECURITY ADMINISTRATION|08-JUN-10|08-JUN-10|10-JUN-10|||/HCGS/520317 /MB...

Thanks for the inputs Craig & Vivek. I am using hash file in between the table and transformer now but there are many constraints and validation that are being performed. The lookup queries are quite fast and its around 12000 rec/sec but at the source it is 600rec/sec and after passing from the ...

The lookup queries are quite fast and its around 12000 rec/sec but at the source it is 600rec/sec and after passing from the transformer its writing to the table at 400 rec /sec though I have changed the arraysize to 10000.

The performance is drastically going down as soon as it reaches the transformer stage. Is it something to do with the stage variables?
There is slowdown in performance while reading from the file and while reading from the lookup as well.

Thanks,
Prasad

Hello Everyone, I have a requirement to update else insert a record while reading from a flat file into an oracle table. The job flow is as below: Oracle table(lookup table) | | | Flat File(21M records) --->Transformer------->Oracle table(with update else insert) My source is a flat file and I am do...

Hi All, I have a simple datastage job where I am extracting the data from a table and I am creating a flat file(text file). These flat files are used to generate reports. But I am getting linefeeds embedded with some of the values coming from certain columns. How can I replace these linefeeds with a...

Sorry for the typing error Chulett. Actually I want to replace the null field with a double pipe. And I want to implement this in my transformer.
Is there any way to implement this? As there are lots of coulmns involved.

Thanks again.
Prasad

Hi, I have requirement like this i need to make a look up between hashfile which has one of the output column as Timestamp(Column name Start_date ) and A table which has one of the output column as Timestamp( Begin_date ).This output is generated by User defined SQL. Iam using To_Date and To_Char fu...

I asked my admin about the same and ha sdone some setttings and code working fine now.i will get the setup been done i will update about this. In my stored procedure. iam just passing the Input parameter and it wont return any OUT parameter.So if the procedure fails due to any exceptions,then will m...

Oracle itself.
can't we make our job wait, till procedure execute completely.

I am calling a stored procedure through the stored procedure stage from datastage.When i call stored procedure,i just fire the call statement and my datastage job finishes.My datastage Job will not wait until the stored procedure executes successfully.So then how i will come to know that procedure i...

Source is In Varchar while target is date(mm/dd/yyyy).

Hi All, I need to Convert date format from 'dd-mmm-yyy ' to 'mm/dd/yyyy'. and i am using th efollowing function to achieve the same.But just the date value (dd) is getting truncated to month start date. StringToDate(DateToString(StringToDate(Trim(LNK_Read_Input.IND_DT), "dd-%mmm-%yy"), &qu...

I have proposed same what you said,but users want it like this only.for every bad record they need mail. Oracle Source-------Transformer-----------Oracle target | | Basic Transformer | | Sequential File I have mentioned IsNotNull(LNK.XXXX) function in Transformer stage.if i get null values, those ar...