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
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What is the difference between a data mart and a data warehouse?
how to perform single sign in cognos by using url?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What are products of cognos?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
What is the difference between set functions and filter function in dimensional data?
i was asked what are the caluclations done by you in your report? plz give reply
What is catalog and types of catalogs in cagonos and which is better?
What is the enterprise class platform architecture of cognos 8?
What is the information present in the cognos configuration file?
What is difference between data mart and data warehouse?
What is the difference between group and associare?