DSXchange

All are good ideas:
1)Enable users to upload screen shots, routines, helpful documents, etc.
2)Provide free and commercial software tools to assist data integration
3)Provide web based training on Ascential products.

Please implement all three things that will really help us.

Thanks

Girish Oak

Hi,

I am new to datastage. I came across Parallel Extender many times in this forum. What is this Parallel Extender what is its use and benefit

Thanks
Girish Oak

Hi Ray, you might find this a bit hectic for you. But I am new to datastage, hence I am asking again and again. :oops: Sorry for the same. My audit table (Audit_table) is in oracle database with dsn name oradb with some username and password. How can I use this table or query on this table using Bas...

What about database?

Girish Oak

heartiest Congratulations Ken, Thanks Ray. Remington Suguru Bland born at 7:40am today, 8 lbs 6 oz, 21" long. We now have 3 boys, all in the last 4 years. If anyone was wondering why I post at all hours of the day, now you know. A pregnant wife and two kids tends to keep you up at all hours. :l...

Thanks for quick reply

Girish Oak

Hi, This topic can be considered as extension of the "Data Stage Scheduling Issue" topic. refer : http://www.dsxchange.com/viewtopic.php?t=85716 In this topic Inner Circle members advices/suggests to keep the dates value in database or sequential file and then use the values from them as p...

Hi,

I have two timestamps in the format yyyy-mm-dd hh24:mi:ss. I want to find the exact difference (sec level). Is there any in-buit routine that can I give me the difference. I know how to get that using Basics.

Thanks,
Girish Oak

Hi Amar, you havenrt specified your requirement clearly. The name of the file will change frequently This doesnt specify the format of your file name. For example : somefilename_[date or timestamp].dat. If the first of the filename that is somefilename or any part of file name is going to remain con...

Hi Kenneth,

I dont have currently with me. Also, I am not very sure whether my client has already installed datastage or not. I am searching this documentation for my own preperation so that I can guide my client if neccessary. Where can I find the documentation other than on CD.

-- Girish Oak

Where can I get the documentation for the same? Are these plugins come by default or we need to load these plugins seperately?.

Thanks,
Girish Oak

Hi, I want to extract data from informix and db2 database. I am not aware of db2 and informix. Does datastage has any plugin to extract data from above said databases. Also, I want to load data in the same kind of database enviornment. I have worked on datastage along with Oracle as database. Can an...

Hi,

How can I find out the number of rows present in a hash file Can any body help me out in this:?:

Thanks in advance

Girish Oak

Hi Vipin, To achieve or fulfill your requirement. What I think is that you should add a column in source table that will hold value 'Y' or 'N' for the row extracted or not. Or you can also put some timestamp column that will hold extraction date for each row. Also to use such solution, you need to m...

Hi Stephen, You are true that we get the list populated only if a table deifination has been saved in directory that to through Manager and not by designer. But if there is no imported table defination, the list will remain blank only irrespective of the DSN entries done in config file. How a normal...