Answer / bharani

IF I were u wll expalin my proj like this

I working for ....(name of the proj) proj,client is ....
(name of the client), which is saless and distribution
domain, technology in my proj is .......(like Informatica
as ETL TOOL, BI TOOL AS COGNOS, Backend database is ORacle)

describe a bit about ur client business a bit.
( suppose for a mall inventory level, itemsold per week and
pregressive businessd timings like festivals)

as a report author i developed ..... these kind of
reports , which are very useful for enduser to take
business decisions.

Generally DWH group contains
1.database team( like oracle)
2.ETL team
3.BI team
4Testing Team
5.Support Team

team 1: perople generally load the data into database and
architect will prepare ER model for that and constraints
ofthe table.

Team2: once data entered into the dbase, Etl architect
prepares star schema for Dwh and Etl developers extract
data from dbase and made some transformations (depend on
business requirements like scrubbing) and load that data
into Datawarehouse in the form of datamarts.

Team3. Bi architect extract the data from Dwh and prepares
a model (universe)and work wll be assigned to Report author
to populate the data in the form of the reports asd per end
user requirement.
Team 4: testing team generally test the report and if any
bugs found dt will be forwarded to support team.
Team 5. this team people try to resolve those issues if it
is not possible for them again it wll transformed to Etl
team.


completely this is a cyclic process.

As of my knowledge.

Bharani working for IBM

Answer / naveen

thank u
it is very useful to all

Answer / vijay kalyan.v

It is always good to know about your Project teams. Report
Authors has to regularly interact with ETL team for data
related Queries.

Answer / priya

Thanks bharanai.im a report developer is it necessary to
explain about ETL process.clarify

Answer / sharath

thanx bharani


nice answer,it helps us a lot.
great patience yaar.

Answer / ramgupta

Thank u ! bharani

Answer / uma

yes its very usefull.....

Answer / bharath

THank you very much Bharani

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

What is Bitmap Index?

0 Answers  

Can anyone tell me the step by step process how to connect cognos to oracle?

3 Answers  

What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

3 Answers  

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

2 Answers   IBM,

How do you improve the performance of the Cognos Analytics report

0 Answers  

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 Answers  

what is report burn and where it occurs

3 Answers   IBM, Target,

i have a table with 3 columns country,empname,salary and i want the query for get the  name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance 

2 Answers   IBM,

WHAT STEPS SHOULD BE TAKEN BY A REPORT DEVELOPER TO INTERACT WITH THE CLIENT SERVER?

1 Answers  

What is the size of database for you project?

0 Answers   Accenture,

i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..

1 Answers