on 09-16-2014 6:49 AM
HI All,
We have a ETL tool Informtica which pulls some of the data from BW and stores in a DB.
At present the Informatica Jobs are failing, due to "Time Limit is exceeded" for reading the BWP table.
as per Basis team advice, Those Jobs are running in a DIA mode and time for extraction is max(4 hours) is already in place and it has to be change to BGD process.
- How to change the DIA Job to BGD process ?
-Is this change has to be done in BWP side or Informtica ? since the extraction is done by Informtica.
- As of now there is NO option to increase the extraction time in DIA Mode.
Kindly let us know your suggestion.
Thanks is Advance !!!
Hi,
if your executing job at informatica side you need to run your job in background.
About those you can check with informatica team who was familiar about job scheduling.
if your executing job in bw then you may used process chains, if yes then those automatically executed in back groundas per the scheduled times.
Another work around:
if your job which pulls data from bw to inforamtica, is possible to split based on selections, then you can split it by using possible filters.
About ETL mechanism am not aware, please think about filtering and pulling less data.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Shashi,
How is the job in BWP scheduled. Is it through process chain. If not you should route your jobs through process chain so that the bgd workprocessers are used.
Also an extraction running for more than 4 hours is going to create problems. So can you check what kind of data is getting pulled up and how.
Regards
Gajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Shashi,
Not much information on how informatica works. But when you are using a 3rd party tools there are connection which supports extraction through Open hub destination. Please check that option.
If you are using OHD the jobs can be triggered through process chain and therefore wont have this jobs running for long time.
there are documents available in net which can provide you on this integration
Regards
Gajesh
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.