DSXchange

My bad... ignore the previous suggestion.. the older suggestion should give you the desired result. Please try again

Please select all the 4 columns as the key in Sort stage for the suggestion mentioned above and try.

In my view, you can name the Source and Target links with specified keywords. Say, READ and INSERT respectively. Write a Procedure to lookout for links with the defined keywords and call this procedure in a sequencer that would trigger a mail.

Ray, Is this a right approach??

Use sort stage (ascending Order) with Row change column- RC.

Then a transformer stage with constraint to output link as :-

RC=1 and @iteration<=Col1
map the input output columns.

Please let me know if it is done succesfully.

Try using DBMS utility function with parameter as the input column. Utility function would be dependent on ur DB..

Thanks for the reply.. It worked.

Hi, I am trying to do a lookup on Char and varchar columns. My job design is as follows:- (DB1 --> Funnel <-- DB2) -->Transformer --> (Lookup <-- Seq File) --> DB Target DB1 has Code (Char 3) and Scheme (Varchar 20) as Key columns DB2 has Code (Char 3) and Scheme (Varchar 20) as Key colums. DB2 howe...

Hi, Please help me developing a parallel job for the following set of input-output data. Input:- Name Subject Marks XYZ Maths 100 XYZ Science 100 XYZ History 100 Output:- Name Maths Science History XYZ 100 100 100 Please note the Subject column can increase dynamically Thanks, Vishal