What is Lookup ,bridgeing tables where they will use in the
Dataware house
Answer Posted / janni
Lookup is One Of the transformer in ETL tool.it can be used
to filter the data in Target table.
there are 2 types of lookup are there
1.connected Lookup
2.Un Connected Lookup
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
5. Which type of report you build more, list, crosstab or chart and why?
explain how to create powerplay reports?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
How can I schedule reports in cognos?
what do u mean by bridge group? where we r using this one?
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
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?
tell me two or three issues from client side and how to solve those issues?
How to create a cube in Transformer? What is the process? Please mention process thank u
What is the difference between Open Connection command ang Open Session Command?
What is defined as catalog and types of catalogs in Cognos?
What are all the types of indexes in Cognos?
Can you define a query subject?