Hey Gurus,
We are currently using Informatica for our ETL and may have to create a model based on Informatica. If any of you have been there before, can someone please guide me in:
1. What information do I need before hand?
2. What are the steps involved?
3. What are possible challenges that maybe I should be aware of?
I remember I saw a blog post once about brining Informatica data into Cognos FM. But, I am simply unable to find it right now.
Thanks for your help in advance,
Chai
Informatica supplies the ETL engine, the mappings and scheduling. The actual model may be deduced by importing tables using RI or by using a specialized modelling tool (like ERWin / Powerdesigner) Perhaps you are confusing Powerdesigner (Sybase) with Powercenter (Informatica) ?
Hey Guru,
Thanks for your response.
The feature I am referring to as attached in the document. Can you please guide me with my queries if you know any information?
Thanks a lot in advance,
Best,
Chai
Even though it looks like you can, I am not sure what you will gain by using Informatica metadata over importing the design from the target database. I guess you could try it, and if it does not work well, take the more traditional approach directly from the database itself.
I agree with bdbits. Importing the defined INFA targets may be technically possible, but it will not yield anything more then the actual tables from the database. Importing other ETL components would make little sense..