DSXchange

In the post check the 4,5 and 6 entries. JP had the same problem and resolved that by changing the uvodbc.config files information. i,e; Loacl host connection.

Happy Holidays.

Think about a person getting Rs.25000 per month. And guess how can he afford this. If you are getting money in dollars not only $50 but $500 is less and worth.

kcbland wrote:Because your profile does not include the DS Engine/bin directory in your PATH. Do "cat /.dshome" to see where the DS Engine resides. ...

It says cannot open /.dshome.

Thanks

Hi

When i am issuing dsjob -run command from unix command line it is displaying command not found.why is this happening.

Thanks

Substantial changes. This is now a completely different requirement. You need to incorporate some algorithm (additional stage variables) to determine whether B is missing (and, presumably, whether A ... The actual requirement is like this Ray and tried it with sunshines method: Input: ID POS NA1 NA...

You can use a Transformer stage or a Modify stage. As well as any "pass through" columns, you have the single column generated earlier on the input link, and multiple columns on the output link. Use ... Thanks Ray, thats a good idea to implement but here i am facing one more issue. using ...

ray.wurlod wrote:You could, but you would probably find it easier to do that in a downstream stage. ...

CAN U PLEASE GUIDE ME THROUGH THIS.

tHANKS

Hi all, Any idea why i am getting this error. Initial_Extract,0: Warning: CopyOfJOB1.Initial_Extract: Sybase Server warning 2762 (severity 16): The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database. I am using sybase OCI stage to extract the data and...

Sunshine2323 wrote:Hi,
Thank You,

Thanks sunshine,This is really amazing.But if instead of dropping them in a single column and giving comma as seperator Can i drop them in seperate colums.

Thanks

Sorry,Here is the complete post. Sunshine2323 wrote: Hi Smita, Job Design: Code: Input----->Transformer---->Remove Duplicate----->Output Declare stage variables as follows: StageVar =DSLink3.No StageVar1 =StageVar<> StageVar1 StageVar2 =StageVar StageVar3 =DSLink3.Type:',':DSLink3.Name1:',': DSLink3...

Hi criag

I am trying to write single row from the multiple rows.

Thanks

Code: Input----->Transformer---->Remove Duplicate----->Output Declare stage variables as follows: StageVar =DSLink3.No StageVar1 =StageVar<> StageVar1 StageVar2 =StageVar StageVar3 =DSLink3.Type:',':DSLink3.Name1:',': DSLink3.Name2 StageVar4 =IF StageVar2=1 then DSLink3.No:',': StageVar5 else Trim(...

I had done a good search on vertical pivot and got some information.But in every posts somebody is asking to search vertical pivot.Is there any particular post which is having complete information.

Thanks

[quote="pavankvk"] After the left outer join,u can check for null value in the non key columns of the right stream and then output the non-null stream to a funnel.----> 1 take the null stream to a aggregator again and this time, ur keys are ID,POS. quote] I am lost here: Left join on ID an...

ok,i can explain step by step Thanks pavan I am having 30 columns.Out of these,i am mainly concerned with 2 columns,but in output i should have all these columns. ID is the main key column. POS is the column on which my transformation depends. I am having multiples rows for the ID like he use to ho...