DSXchange

Just giving the thread a little bump

1 more thing check the keys defined in remove duplicate and lookup i hope both are same uuuupssss........it seems you found the problem...... Anyway, this fixes the warning in the lookup stage, but still I cant get desired results This just became a sql query issue, you may help me, because I must ...

This is what it does I/P value = 23.56 O/P value = 2356 ( removes the decimal point) I/P value = 23 O/P value = 2300 ( adds 2 0s implying no decimal point and integer value) I/P value = 23.4 O/P value = 2340 ( adds the 0 for the 2 values after decimal and removes dec point) I/P value = 23.456 O/P v...

1 more thing check the keys defined in remove duplicate and lookup i hope both are same and dont add period it will give you 1 record after each XXXX record defined as period use skip instead. get record number 2257 and add the keys in transformer above in constraint and check how many records you g...

Could you add a peek of all rows between remove duplicates and lookup and manually check row 2257 +- 1? I know that Peek stage gets data from an input (in this case, the rem dup stage) ... but....can output this same data to the lookup? How shall I check those records manually? in the peek? how? Th...

ArndW wrote:That machine name looks very familiar!

What stages are you using in that job? ...

3 row generators -> funnel -> sort -> remove duplicate ->switch ->2 datasets

a simple job to test

and I think you have worked on this system for your previous assignment

Hi All, When i am trying to run my job on more than 1 node, it aborts with few fatal errors like RemDup,0: Failure during execution of operator logic. RemDup,2: Fatal Error: waitForWriteSignal(): Premature EOF on node iehibu12 Socket operation on non-socket main_program: APT_PMsectionLeader(1, node1...

I think converting to the internal date first is better. To a StringToDate() call and then later a DateToString() with appropriate formatting. I think DataStage too uses a century pivot to decide the century by default its 30, if its less than 30 it considers it as 20YY and if its >30 then its conv...

Disabling Combination means set APT_DISABLE_COMBINATION to True
Else it combines the operator to optomize the performance.

What happens when you perform lookup for only those 4 tables?

is the result same?

Hi Birendra, I tried splitting the tables with two lookups but still facing the same problem. I checked the job monitor after adding two lookups and found that the reference tables from both lookups are loading at the same time. I think this is the issue as if it's load the reference tables from fi...

Preventing the jobs from aborting would be favourite. What compilation options have you set in your job sequence? Are you using explicit Failure triggers on the Job activities? Is there an Exception Handler in your job sequence? Yes, thats what i prefer too. yes we have exception handler in the seq...

hello, I have an issue here. I am doing a sql query from oracle enterprise stage.Here i am using some aggregate functions like count(*),sum(colmn1). Its meta data is defined as integer in the job. its throwing errors like floating point error. i dont hv the exact error message with me right now i w...

Hello, In a sequence I have an execute command which calls a bteq to populate a table. Upon successful... the sequence continues to executes the next stage, which is a datastage job that joins the table that is populated in the previous stage with another huge fact table. Most of the time the first...

It's the restart logic code. That's why I suggested recompiling. Hi Ray, I recompiled that sequence and ran again it worked fine. but I am getting this warning in 90% of the time when any job aborts. Is there any work around that can restrict these warning and abort the job normally. Regards,

Hi I am facing problem in importing date format data from csv file. where date format is "2008-09-12". Please let me know how to resolve this issue? First of all tell us what/how are you doing this. why dont you just try to parse that inside DataStage after reading it as varchar if proble...