can any body explain clearly how to explain any (sales)
project in interview.actually feom where report developer
work starts?pls reply as soon as possible.
Answer Posted / 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
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
what is degenerate key in oracle ?whare do we use it?
What is the difference between drill through, drill across?
how you create security to reports?
how u will determine the performence tune will occur either in report or system
Can you define cognos impromptu?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
what are the errors faced while bursting the reports and how to solve those errors?
What is the model filter?
how can I test reports in cagnos?
What are all the types of indexes in Cognos?
Explain the characteristics of cognos?
faq's on cognos
How we check the errors before running the report?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?