In datastage how we can do for this type or requirement:The sales data will be extracted in 2 flat files.Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIPif suppose we run first time means the job names are
How to call a Stored procedure which is in SQL Server database in Datastage job? I want to pass job parameters as one of the SP parameters and for remaining SP parameters , I want to use default values. Also I want to perform transformation on the result set of SP.
Latest Answer: It's very difficult to have a good usgae analysis in oracle and see exactly who is touching what and how on table and column level. However I know that there is a good tool called DB*Classify that provides this information and much more regarding the ...
Hi Everyone, I've loaded datastage 7.5 in my PC running Windows 2000 server. Installation was successful but while running any designer, manager or administrator it is asking hostname, user and password.. I've given hostname : localhost, user : Administrator and password for the same. but it is giving an error in connection "Failed to connect to host: Localhost, project: UV(The connection was refused or the RPC daemon is not running (81016))" ...can anyone help me ...thankx in
Which we have to use for export the jobs from client to server,if sever running on Unix os and client running on windows os?
Latest Answer: Routine : Routine is like procedure which is called to process certain operation.GoSub ADD(A,B)ADD(A,B):C=A+Breturn C ...
Latest Answer: Also find out the PID number from datastage director in cleanup resources link and go to the UNIX server and kill PID number. This way you can easily kill the process and it gets unlocked. ...
Latest Answer: These are the three types of files will be created .dat, .type, .over ...
Latest Answer: 999 MB for reading data into file.999 MB for writing data into file.Thats Approx.2GB for whole Hash File. ...
While using oracle database as target or Source why we will use OCI stage why don't we use ODBC stage?
View page << Previous 6 7 8 9 [10] 11 12 Next >>
Go Top
