DSXchange

yes you can use target database as reference lookup. If you use sparse lookup then thelookup database definetly recognises the newly inserted record. Reading and writing to the same database table won't be a problem. But when you use a sparse lookup you get performance issues if your driving and ref...

You can interpret most of the times from the log message from director.
Check if Orchestrate Operators Reference guide pdf might help.

The row will be checked for all the output links and the order in which output links process a row depends on the link odering. The initial order of the links is the order in which they are added to the stage and if you want change the order of output link processing you change from link ordering tab.

If you want to read entire record in one column.
Find the possible max length of the record and specify the lenth of the column with that value and datatype as varchar...

Convert the dates to julian date and compare them..

I had a scenario like this... I wanted to insert a record into a target database if I find zero records in the source database. Here I have used count in sql query of the source database, which has given me a row with 0 as value. I have checked the count in the transformer stage and if count is 'Zer...

Sanjeev kumar,

Did you get solution to your problem.

enable inter-process row-buffering in the job properties in performance tab and also please close the topic.

Hi,

If you got solution please give the solution so that others can benefit from the same and also close the topic (mark resolved)

We cannot put comments inside a derivation.

I believe you can check with Iconv function.

Can you explain the fix you made to the problem.
It will be helpful to us.

Craig, I am able to find these files in my Version Control Project directory. I'm able to list these file through Administrator command prompt. I am also able to get some information if I run the command SELECT * FROM APM.BATCH. When I tried to select only DESC Column (SELECT DESC FROM APM.BATCH) I ...

You can achieve this with Index function also.
Find the position of 'X' with index function then you remove 'X' with substrings function

sanjumsm, While writing the rejected records if you have multiple errors for a single record how can you distinguish between them? Based on error descriptions? How are you adding your error descriptions? Are you using one column which contains all the error description for that particular rejected r...