how to read the data from XL FILES?my problem is my data file having some commas in data,but we are using delimitor is| ?how to read the data ,explain with steps?
Latest Answer: Yes, its like a disadvantage of staging area, it takes more space in database and it may not be cost effective for client. ...
Latest Answer: HI,is this only related with server jobs .because in parallel extender these things are taken care by stages ...
Latest Answer: the Surrogate key will be the key field in the dimensions. ...
Latest Answer: Create a new DSN for the Excel driver and choose the workbook from which u want dataSelect the ODBC stage and access the Excel through that i.e., import the excel sheet using the new DSN created for the Excel ...
Latest Answer: You can generate through system variable in transformer which is built-in name is keymgt. You don't have remember full name and in parallel you can generate through surrogate key generator. ...
Latest Answer: Here is the full FAQ on this topic:Creating project specific environment variables- Start up DataStage Administrator.- Choose the project and click the "Properties" button.- On the General tab click the "Environment..." button.- Click on the "User Defined" ...
Latest Answer: Thanxs... ...
Latest Answer: these files are stored in the memory hence faster performance than from a sequential file ...
Latest Answer: You have to install Windows 2003 Server enterprise edition with SP2 or more and .Net framework for Datastage PX or Unix OS. If you have installed on Win XP it wont work properly. For Datastage TX you can install on Windows XP ...
View page << Previous 10 11 12 13 [14] 15 16 17 18 19 Next >>
Go Top
