DSXchange

Will you be always looking for [if custid is 1000 and eff.date is feb/12/2002, and number of installments are 4] it doesn't make sense. What you can do it is, Read the incoming data......check the conditions in constraints (have 4 output links) in all the 4 output links check the constraint custid=1...

I guess, you are doing schema validation, try not to do the schema validation it might work................

vijayrc and us1aslam1us reply was very helpful.

Thanks a lot.............

Hi Prasad, If col1 values are consistent( 'M','C' & 'U'). Use the transformer stage to filter the col1 using constarints and to get three output streams.Define a common dummy column in all three outstreams with the same constant value.Next use the merge stage to merge all the three streams. Or ...

Hi All, This is one of the requirement, need help Input data col1|col2 M|abc C|def U|hji M|ad U|ryer M|fntry C|rtf U|gsfdg Ouput col1|col2|col3 |col4|col5|col6 M|abc|C|def|U|hji M|ad| | |U|ryer M|fntry|C|rtf|U|gsfdg whenever an M starts the data has to be entered in a new row. Regards Prasad

chulett wrote:What changes are to be made to what precisely?

You should call your routine using the Routine Activity stage and then check the $ReturnValue of that in your trigger expressions.

This was a really a smart logic, that works now.
Thanks a lot.

Experience really make a difference.

Hi All, I have written a routine to get the row count of a link, it works fine in some places, in sequencer(trigger column) some places it wont. http://www.dsxchange.com/viewtopic.php?t=109694&highlight=.dsk Based on the above link can anyone tell me wher is .dsk files are stored or what are the...

SO in the entire dataset, if you find ABC in col2, then change col3 value of all associated with identical first col, and the rest of the data will have zero? Did I understand you correctly? Yes thats correct. To more elaboarte, I have added one more set of example Input 1 | XYZ | 207 1 | ABC | 207...

Hi All, How to implement this Ipt_Col1 | Ipt_Col2 | Ipt_Col3 1 | XYZ | 104 1 | ABC | 207 1 | DEF | 302 2 | MNO | 403 2 | PQR | 560 2 | UVW | 30 Transformation rule is, whenever there is a ABC in Ipt_Col2 then the value associated with ABC is replaced in all the columns of Ipt_Col3 with the correspon...

No. Use two Lookup stages. Run the reject links from them through a Funnel stage to accumulate the rejected rows. Or make the lookup failed rule on the first Lookup stage Continue, and perform the ... Currently I am using two lookup stages. First lookup then reject into a funnel and then second loo...

Hi All, how do I get datastage to output apostrosphe ' instead of ' in my XML output. For example I want St john's but data stage is outputting St John's . Is there a way to override it? Thanks This looks only in the UNIX environment, when you look in the windows environment with ...

Hi, Source file has 4 columns Src_col1, Src_col2, Src_col3, Src_col4. Lookup table1 has 3 columns lkp1_col1, lkp1_col2, lkp1_col3 Lookup table2 has 3 columns lkp2_col1, lkp2_col2, lkp2_col3 Target file has 4 columns Tgt_col1, Tgt_col2, Tgt_col3, Tgt_col4 Reject file has 4 columns as coming from the ...

Hi,

If the DataStage job has scheduled from admin userid.

Is there a way a regular user can view the schedule and see the job ran successfully or not?

Regads
Prasad

novneet wrote:Please let us know what was the resolution for the issue?

I used the Tag case value in the table definitions of the column it worked!!!!!!!!!!!!!

???