DSXchange

Iam not with Datastage now, pls check if PadChar function can replicate string instead of just char. If so you can replicated the field concatinaed with a new line character.

Try the first step as using Cleanup resources in Director. User dsadm id for it.

Thats greate. So we can expect more from you to this site.

Is it always with half an hour gap irrespecitve of the time?

If you know the column length for sure, concatinate each column together, (either afeter using NullToEmpty) and fetch the first n digit corresponding to the column length. If the length is not know, concatinate with a delimeter. Trim of the leading delimiter. And fetch data till next delimiter. You ...

Do you want a replacement of unconected lookup? Here lookup with links will server the same purpose.

Do you get any other warning or error along with this. Is all you derivation proerly mapped?

You can use ODBC/OCI to call the stored procedure. which will return the result set to datastge.

You can avoid aborting the job with this message by removing the option of abort if no match. But ultimately you need to find the reason why you didnt have the match for fact over the dimension table. Hope the replies for all of your 4 post might have given you an idea that by doing a search on this...

By the way, please avoid SMS type english, "u" "y" "ur"..... Lets make the question aswell as the answer understand by all.

Lookup will be good and effecient enough as long as the lookup data was able to find into memory.

What is the datatype?
Just try to print Col1[1,2], if by chance preceeding zeros getting trimmed, it will give you A.

Chris Thornton had posted a ecase for this - ecase 36053.
You can always balance the load of the server by scheduling the jobs with some time lag.

By the way, what is second columna and what is third column?
Have you given any constrains, used in any stage varialbe?
Try to map this value in a integer.
What is the job design and what are you trying to acheive?
Hope you have tried running in a sequential mode too.

Another quick and detail reference "DSXchange".