Typical Roles In DWH Project
- Project Manager: This
person will oversee the progress and be responsible for the success of the
data warehousing project.
- DBA: This role is
responsible to keep the database running smoothly. Additional tasks for
this role may be to plan and execute a backup/recovery plan, as well as
performance tuning.
- DWH Architect: This role
is responsible for developing and implementing the overall technical
architecture of the data warehouse, from the backend hardware/software to
the client desktop configurations.
- ETL Developer: This role
is responsible for planning, developing, and deploying the extraction,
transformation, and loading routine for the data warehouse.
- OLAP
Developer/Reporting Part: This
role is responsible for the development of OLAP cubes.
- Platform
Architect : Responsible
for the Overall Infrastructure Build.
- Data Modler: This role
is responsible for taking the data structure that exists in the enterprise
and model it into a schema that is suitable for OLAP analysis.
- QA Group: This role
is responsible for ensuring the correctness of the data in the data
warehouse. This role is more important than it appears, because bad data
quality turns away users more than any other reason, and often is the
start of the downfall for the data warehousing project.
Hi
ReplyDeleteI am facing issue when I am trying to connect salesforce.com by Informatica 9.1.
Bellow error is showing
Login Failed.Errorcode:[SOAP-ENV:Client] Reason:[Timeout].
using Service URL:https://test.salesforce.com/services/Soap/u/23.0
Also I have set proxydetails in C:\INFORMATICA\9.0.1\clients\PowerCenterClient\client\bin\pmsfdc.ini.
ProxyHost=
ProxyPort=
ProxyUser=
ProxyPassword=
Please can you let me know what is the resolution of this?
Thanks
PP
Have the proxy server details set in your Internet Explorer.
Delete• Tools > Internet Options > Connections > LAN Settings > Proxy Server.
• And also add the proxy host name and ip in C:\Windows\System32\drivers\etc\hosts.ini file.
Please go through my post about sales force.
How to connect to Sales Force (SFDC) From Informatica
I would like to say that this blog really convinced me to do it! Thanks, very good post. architecture
ReplyDeleteThis is extremely fascinating substance! I have completely delighted in perusing your focuses and have reached the conclusion that you are right about a hefty portion of them. You are extraordinary. House blog
ReplyDeleteThanks foor posting this
ReplyDelete