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.
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 23 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sharath
thanx bharani
nice answer,it helps us a lot.
great patience yaar.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is your project workflow and your role in the project?
How you create IQD In ReportNet FrameWork?
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
How to schedule the report in Cognos? And i have 2 users u1,u2. how to schedule the report for these 2 users(the 2 users will get result once for a week) but u1 get the result on every monday to his inbox,and u2 get the result on every wednesday to his inbox.
Why cognos decision stream is used?
1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?
What are links & Segments in Cognos Framework Manager?
What is the use of powerplay web viewer in cognos?
what is report burn and where it occurs
-------------How you design DWH?
what is the use of macros&folders&herarchies in frameworkmanger?
What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?
1 Answers Cognizant, Niteo, SacSoft,