DSXchange

Ammm hmmmm, yes

That's what I am doing in the Child Sequence but I am only using the Terminator in the Parent Sequence.

Once I add the notification activity before the Terminator in Parent Sequence, I will get the emails.

Thanks a bunch! You made my day !!!

I have two types of Sequencers, lets call them Child Sequencers and Parent Sequencers. (1) The Child Sequencer that calls a job and some routine is sending emails when any exception/abort occurs anywhere within that Sequencer. I am using the Termination Activity Stage besides each stage and finally ...

Shamshad's hint worked. I don't have any JOB ACTIVITY in the Master Sequencer.

I have a Master Sequencer. From all stages, I have two output. (1) When the stage is OK, the control goes to another stage. (2) When an error happens, the control goes to notification activity. I added Termination Activity stage and joined to all the notification avtivity that executes when an error...

In 7.5.1 we have a 2 step process to read mainframe flat file with COMP fields. (1) Job 1: Using FTP get complete column in 1 field and dump in text file. Example: if file has 10 columns total 1000 char, read as varchar (1000) in the transformer / source. The FTP transfer type is "binary"....

Lookup Source should only have 1 record per lookup key from the transformer. Ideally lookup should only match on 1 row in the lookup source and return that row only. Fix your source and see there is only 1 row per primary key. Note: Please get premium membership. I have been a premium member and tel...

Hello, I have a parallel job. In the transformer, all I need to check if my first column of the source which is 1 character long contains any 1 these character ( any number from 1 -10, or any letter A - Z). If the column has any other character other than above, I want to simply reject the row. Is t...

I agree with you 100% that with different Sources and Targets design and implementation Practices may be different. It would have been ideal to come up with 1 document that covers some common scenarios. I am looking into some very basic area like (1) How many max tranformer to have in 1 job? (2) How...

Does anyone has a document that explains some of the best practices

- Design and Implementation of ETL Code
- Naming Standards for ETL Jobs and Sequencers.
- How to design restartible ETL jobs etc.

Any help will be much appreciated.

Shamshad,

Thanks bunch ! It works as you mentioned in SERVER JOB. I am sure it will work in PARALLEL JOB too.

Thanks once gain. I love this Forum.

So, if all my parameters are in a Sequential File, I should design my job this way in a SERVER JOB?

(Server Job)

SQL FILE > TRANSFORMER > ODBC Stage

I don't have ODBC STAGE in my Parallel Job pane but I only see ODBC ENTERPRISE. So can I design SERVER job to accomplish this?

I have a SQL Server Stored Procedure that updates a table. The procedure has to be run for multiple rows and should return nothing. How can I call SQL Server Stored Procedure and pass multiple rows as input? Definition of Stored Procedure USE [IBMDB] GO /****** Object: StoredProcedure [dbo].[IBMEDW_...

I have a DB2 Stored Procedure that takes input parameter and returns me result set (5 columns ) from cursor. I am able to connect to DB2 Server from my UNIX BOX and run the stored procedure and I get the resultset on my screen. Below is what I do:- source /mycomp/thisproj/proj/Ascential/DataStage/DS...

I am executing a Stored Procedure from STP Stage. It is creating and populating my resultset with the data I want in a cursor. The DBA says in order to get the data from cursor, I have to "Fetch" the cursor and then read the cursor till end of data. "How do we READ/ACCESS the CURSOR t...

(1)
The same stored procedure runs fine on DB2 Connect interface. I pass input parameter and it gives me the resultset.

(2)
The reason the Stored Procedure is transform type because it takes 1 INPUT PARAMETER.