DSXchange

In server it does not matter. In px it does. If you have any background in programming, especially c, you will know that characters are not the same as integers. They need typecasting to be changed from one form to another. Similarly with PX, as it is strongly typed like C, you need the conversions...

Hi, Can somebody help me how to use quality stage...I am new to it...I want to learn ...I have a file to cleanse 2 things so i'll appreciate it if somebody can help me out... Thanks... Starting to learn QS without a mentor is quite messy specially if you use the provided documents. Start with the d...

DSguru2B wrote:AsInteger() and StringToDate().

Why do we need to use this function if i am sure the data contains all integers and dates respectively?

I cant check it out as i dont have parallel installed with me. Can you please help me out on this?

Hi, Can somebody tell me, In Quality stage how do we get the data direcory of the project directory we already created... Help will be greatly appreciated... Thanks... Can you elaborate please? your question here is too confusing. What exaclty you want to know? you said you have created directories...

Just make sure the input field is integer and map it to the output field. same goes for other data type conversions. You need not do any conversions if you are sure that the input data values correspond to the output data type

Rohit Can u please tell me how to create the log file other than what Director maintains?? I just told you how to get 3 days log into your files. (something what arndw had already said). What kind of log files you want to generate other than director? you may want to run a routine which will store ...

a) As dim_clt has to be done prior to clt_dim1, clt_dim2. If dim_clt has to be done prior to clt_dim1, clt_dim2 Then extract jobs for dim_clt should be done prior to clt_dim1, clt_dim2. Unless there is there no dependencies of clt_dim1, clt_dim2 on dim_clt. Did I understand you right? Its not loadi...

did you do a searh on this error code here? i got 121 results.

start with this one:

viewtopic.php?t=98717&highlight=141

It saya this error code is when DS is not able to log into UV.

Hi, Thanks for the response.Right now we are using a look up and achieving the purpose. But this is time consuming in real time so we are in a position to write a routine for this Thanks, Prathyusha Why not dump the table into a hash file using datastage and then use that hash file for your lookups...

dwblore wrote:Ray,
3) The number of rows showing the warning is same as the distinct rows of A in the reference lookup table.

Is the value of A same in all those distinct rows or you talking about all distinct values of A?

What is the one value of A you are passing through the source file?

Hi, I want to archive my Logs Automaticaly in some directory. As far as i know,we have two options to maintain Logs : (1) Auto purge logs over SOME Days.So it will maintain the Log files for job run upto those many runs and after that duration the logs will be purged. (2) Take a print of the logs a...

I am having the same problem again today. I edited a job and saved it (I was able to open DS designer). When I went to compile, I got an error as if there was a syntax error compiling. So I changed it back to where it was before and tried to compile. Same error. I closed DS designer. I then would N...

Extraction does not depend on any of your relationships as far as none of your tables get updated. So if you have extracted dim_clt and then while extracting clt_dim1, dim_clt adds/delete on one more row then you may face difficulties as far as referential integrity is concerned. So to be on safer s...

Is the stand stage running through GUI? i mean without the job? is the input to this stage a fixed width file?

Greetings...we have a job that has been running in our production environment for several years now with no issues. Our last run produced the following fatal errors: Funnel_23,0: Failure during execution of operator logic. Funnel_23,0: Fatal Error: APT_SYSselect returned error status -1 and no inpu...