DSXchange

Hello mrinal, Before finding out the problem we may need more info. 1. Is the job running fine when ran independently? 2. How can you say the problem is because of the funnel? What are the other stages in the job. Can you give more info on the job design. Probably the job is running infinitely. Just...

Hello Baha,

Can you please mail me the document dsR3.pdf to my email id
rsrikant@gmail.com.

Thanks in advance.
Srikanth

Hi,

Can anyone provide me documents on Ascential PACK for Siebel and SAP BW?

Do we have any developers guides for these PACKs?

I am trying to understand on how to create interfaces into and out of siebel and SAP.

Any documentation or guides can be of great help.

Many thanks in advance.
Srikanth

Thank you for the reply Ray. The solution you gave is working after using Basic Transformer. In basic transformer i am able to achieve it even by using Fmt function. But the client is not accepting this solution. He wants pure PX solution. How to build a custom operator? Do you mean building a custo...

Hi Everyone, One of the requirement for my job is to represent a decimal number with thousand separators. I have gone through various inbuilt functions available in parallel and not able to find one which can solve this purpose. For e.g., the decimal 1234567891.23 should be represented as +1,234,567...

Oops!!!

Rich and I thought we could meet you in person if you are in chennai and don't mind meeting people.

Regards,
Srikanth

We don't need 12 if then loops.... since the end date of a month can only be 28, 29, 30, 31 and we know the end date for all the months, two loops for 30 & 31 and one nested loop for feb is enough. But I feel there should be a better way of doing then if then else loops. Anyone has some idea on ...

We are using Datastage 7.1 EE with parallel extender. We don't have the problem you have mentioned. In the job parameters, this environmental variable is used and the default value can be changed by us. I am not sure whether it is corrected in 7.1 or some setting is changed by our Datastage administ...

Thank you Ray.

Vow!!! that's simply a great solution.

Thanks Ray.. I am adding to my favorites. :D

Srikanth

Hi, We do get this problem frequently. I believe it's a time out problem. If we don't work in the designer for sometime and if it's idle, this problem comes. I don't know if there is any way to increase the specified timeout for this connection broken. If yes, probably we can increase that. Has anyo...

There are people on this site which would like some process which separates the experienced from the newbies but I doubt if anyone can write a test to do that. Look at all the Oracle certified people which are totally not qualified to be a DBA. I think most corporations understand there is a differ...

Hi Craig, What if the 10 digit character in the 3rd column has a value of length <=3? If all the rows have a value of length >3 in the 10 digit character column, probably what you said can work out. By what raj mentioned it's not clear whether all the rows are of length >3 in the 10 digit character ...

Hi Henry,

This is a syntax problem.

Each statement in a Begin End block in PL/SQL should terminate with a semicolon.

The code should be
HTH,
Srikanth

I think Mike has answered your question completely. Load the data from table 2 into a hashed file. Use a ODBC stage for table 1. Use a transformer which uses both ODBC & Hashed file (used as a lookup) stages as inputs and map the foreign key from ODBC stage to the primary key hashed file stage. ...