We have to choose between Datastage and Informatica.Which of these is better?Our DW is approx. 3-5 GBEnvironment is NT.We have INFA 7.2 and the business we just took over has Datastage 7.5. Here's one side of the story:A customer that recently migrated from Ascential DataStage 7.5 to Informatica PowerCenter 7. The customer has identified that Informatica outperformed Ascential DataStage in the following areas.· Performance - Informatica PowerCenter 2.5x faster than DataStage
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
NEED HELP1) I can not get into DataStage Administrator after trying a lot. I give the Host Name or Name of my computer, and I did not give the User Name & Password then I get the error like thisFailed to connect to host: ishaq, project: UV(The host name specified is not valid, or the host is not responding (81011))2)When I give the Host Name User Name & Password then I get the error like this Failed to connect to host: ishaq, project: UV(The host name specified is not valid, or the host is not
If i run the job first 10 times there is no time variation in job execution.In same way i run the job for 100 times it takes 10 times extra time.what is the solution for it?
How to view the last compiled time of any datastage job, after the job has been finished (run) successfully?
I know we use them in the project level and also in the job level and also that we can give values at run time(like UN, Pswd etc). Theoratically I understood. But practically unable to implement it. Can
Latest Answer : For example I create a parameter for my hashfile folder like it :
Name: $pHashdir, type:string,def.value:†C:DataStageInput DATAHashâ€
and when I use my hash file in path file name i use just this parameter $pHashdir
and when you run ...
Latest Answer : hi,first check in the director's log about the job condition.if you cannot find the errorgo to the input to output datatye conversions.or elsecheck the configiration file APT_CONFIG_FILE ...
What is the order of execution in the transformer?
Latest Answer : Transformer execution order is Constraints, Stagevaribles then derivations. Pls correct me if this answer is wrong.Regards,Veera. ...