DSXchange

Hi Everybody, I need help on urgent basis and i would be greatful if you can provide me the solution. I have some tables where the no. of records is very huge and i want to do an incremetal load for them. The criteria for this is Selecting the Records after a specified Date. Now the value of this Da...

Hi All, I have to remove leading zero's from a varchar field....the scenario is like...i have the value's like 000876 and 000etywe now i have to remove the leading from only those records where it follows numeric value after the zero's.... It should be 876 and 000etywe can any one tell me how to do ...

Hi All, While loading the data from source to target some time my is running fine and the same job for same number of records and without any modification its getting aborted..... Following are warnings and fatal error...... node_node2: The open files limit is 2000; raising to 2147483647. node_node2...

Hi All, While loading the data to the target table sometimes i am getting the error following message :- subArgs={asc}}},0: Failure during execution of operator logic. subArgs={asc}}},0: Fatal Error: waitForWriteSignal(): Premature EOF on node cdnlodb1 No such file or directory subArgs={asc}}},0: Fa...

That's what I pressed to get help from Datastage Guru's.... , Actually I searched it but didn't get the proper answer....can you plz explain me...about this property?


stiwari

Hey Guru's

I just wanted to know the functionality of the constraints of the lookup failure......for the DROP......is it drops those records, those doesn't match with the joining condition or somthing else......?


stiwari

Thanks guys....ya, I got solution of all the issues. I got very quick replies with the valuable solution.....i mean the people on this forum helped me a lot.
thanks once again to all the Datastage guru's :D


stiwari

Hi All, I am trying to load 120 million record to my fact table....instead of using join i am using lookup to join all the dimention tables....but after loading 40 million record its getting aborted. Error message is :- Failed to keylookup for record I am not able to understand what error it is....c...

Kirti,

Thanks for your quick reply, I have tried this logic it's working fine... :D

Regards
stiwari

Hi All, While loading Target table I have used left outer join/right outer join with join stage but performance wise it's very slow now I want to use Lookup stage instead of join stage but there is no option to take any Outer join.....If any one have any idea...Plz share it with me...... Thanks in a...

Kumar,

I am using lookup type as normal......Is it really matter that i have to use lookup type that won't be using Scratch file this much....


stiwari

Hi All, I am loading 1.2 billion to my fact table, I have used LOOKUP stage to join all the dimentions. When I kicked off the job it has started at very good seed but when it had reached to .5 billion, It got aborted ...Log file showing UNIX Signal SIGKILL 9...that means that job has aborted forcefu...

Hi,

I am using User defined SQL as read method....yes, DB2 database is partitioned......and i have also tried with one node, facing the same problem.

Arndw,

I am using source and target as DB2, Number of nodes are 4.
I have tried with Sequential file instead of using Target table but my job keeps on running and not fetching any record.

Hi All, I have created one job to load the data from source to target. When i have loaded the data from one schema( which contains 110000 records ).it was working fine. But i have started loading data from other schema( which contains 120 million records ), it has started fetching at good speed but ...