Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone tell me the step by step process how to connect
cognos to oracle?
- 3 Answers
- 7744 Views
- I also Faced
- E-Mail Answers
Answer Posted / sunil
I think when during the ETL process ETL people will do the
connections to the required RDBMS in the form of ODBC
connections in taht way they can import the tables from
data source to target table (i.e in data ware house) data
warehouse acts as a data source to the BI modelers for
creating the interface.the project contains query
subjects .which contains the SQL statements.so ETL people
do the odbc connections during ETL process.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Is it possible to join multiple Databases in a Catalog?
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?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What are types of batch available in cognos?
What is the difference between set functions and filter function in dimensional data?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What do you understand by user class in cognos?
Can you define a datastore in cognos?
Explain what is the main advantage of impromptu over cognos reportnet?
What is called Cognos powerplay?
What is called cognos reporting tool?
What are the other methods working as deployment functionality?
What is the difference between ‘macro’ and ‘prompt?
Can you define materialized view?
