DSXchange

Good said Ray , Let me take Hammer and bang their heads .

'volunteer' :D . For the past 8 years I have been working on J2EE,Oracle,Seebeyond and Datstage . My managers introduced me to client and in the discussion one funny guy got this silly doubt and did put me in trouble .

I did search on internet ( asked Google uncle ) , Oops no answer

Thanks a lot Ray and chulett for your responses. They are going to stick to Oracle (That is what the message I got from business , But of course no body know the future) They are asking me to prepare a Presentation on comparisons and differences of these two tools. ( In the end of presentation I hav...

Yes you are right Sun bought it . It is now JCAPS.
It is an integration tool

Could some body please help me on this? For a given scenario how do we chose which product exactly fits in ( I mean to say the comparison between Seebeyond and Datastage) I listed down some of the points for both of these 1) Data Volume me is high go for Datastage 2) For complex scheduling go for Se...

Hi ArndW,

Thanks again for your time . I agree definitely I am an idiot .

Mistake what I have done is I selected Lookup type as NORMAL and trying to use ORCHESTRATE. I changed it to Sparse It is working fine .

In tension you lose every thing

Once again I thank you

-Srini

Hi ArndW,

Thanks for your time for replying .

I tried auto-generated syntax .It is just showing the following other than this it is not helping much.

SELECT
empno,sal
FROM
<<Table>>

Srini

Hi ArndW, Thanks a lot for your response . But in my case auto generated sql doesn't work . I used the following select empno,sal from emp2 where empno like '%'||ORCHESTRATE.empno||'%' even when I try select empno,sal from emp2 where empno =ORCHESTRATE.empno It is giving run time error saying "...

Hi Ravi,

Thanks for your response,

Unfortunately the look up database is not in our environment and we can not load that data into our environment(Huge table) .

I am worring why I can not use ORCHESTRATE in lookup table and why I am getting this error

Regards
Srini