Data Warehouse Interview Questions

 
1.
What does dependency analysis mean in Ab Initio?
2.
When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
3.
Describe the Grant/Revoke DDL facility and how it is implemented?
4.
What is the difference between rollup and scan?
5.
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
6.
How can i run the 2 GUI merge files?
7.
Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e.: a test and production copy of a database)?
8.
How would you find out whether a SQL query is using the indices you expect?
9.
How to create repository in abinitio for stand alone system(LOCAL NT)?
10.
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
11.
Explain the difference between the truncate and delete commands?
12.
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
13.
How can you force the optimizer to use a particular index?
14.
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
15.
Why might you create a stored procedure with the with recompile option?
16.
What is the purpose of having stored procedures in a database?
17.
What are Cartesian joins?
18.
What is an outer join?
19.
What are primary keys and foreign keys?
20.
Have you used rollup component? Describe how?
21.
How do you convert 4-way MFS to 8-way mfs?
22.
What is AB_LOCAL expression where do you use it in ab-initio?
23.
What is the latest version that is available in Ab-initio?
24.
What is $mpjret? Where it is used in ab-initio?
25.
I am unable to connect sever database(oracle) from GDE(db config file) local system.i set all these?
26.
What is the Difference between DML Expression and XFR Expression?
27.
How Does MAXCORE works?
28.
What is the syntax of m_dump command?
29.
Can anyone give me an exaple of realtime start script in the graph?
30.
What are differences between different GDE versions(1.10,1.11,1.12,1.13and 1.15)?
What are differences between different versions of Co-op?
31.
How to run the graph without GDE?
32.
What is local and formal parameter?
33.
What is BRODCASTING and REPLICATE?
34.
What is the importance of EME in abinitio?
35.
What is m_dump?
36.
What is the difference between a Scan component and a RollUp component?
37.
What is skew and skew measurement?
38.
How to get DML using Utilities in UNIX?
39.
Explain Difference between onRow and Onread method?
40.
How do we have left -right flow , normally its top-down flow?
41.
What property you use to Hide a control at runtime?
42.
We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?
43.
I generated one report design time i
can color green. at run i want bule how to change dynamically? and which method i can over write?
44.
What is AFC? Where we Use AFC in Actuate?
45.
What is the filter?
46.
How to call a stored procedure from a report?
47.
Connecting to iServer Volume using IDAPI
Classes(Java Classes) and after connecting to iServer i want to execute the ROX on iServer and also want know the status whether that job
is succesfully run or not?
48.
How many times executite the fetch method at run time?
49.
What is data stream and data adaopter is it same are different? explain?
50.
How to implement the parallel report?
51.
How to generate a report by getting values from two reports. the generated report should contain the 5 values of first report and last 5 values of second report?
52.
What is the difference between
-using Group by in the SQL of the report
-having a Group section in the report?
53.
Can we define global methods in a report?
54.
Can we connect to 2 different types of database through the same report?
55.
What is report bursting?
56.
What is page level security?
57.
Which cmponent has onRead method and what it is used for?
58.
Explain Differences between star and snowflake schemas?
59.
Explain the data type of the surrogate key?
60.
What is a CUBE in datawarehousing concept?
61.
Explain Why fact table is in normal form?
62.
Explain What are the possible data marts in Retail sales?
63.
Explain degenerate dimension table?
64.
Explain hybrid slowly changing dimension?
65.
Explain conformed fact?
66.
Explain BUS Schema?
67.
Explain What are the advantages data mining over traditional approaches?
68.
Explain Difference between E-R Modeling and Dimentional Modeling?
69.
What is a Fact, Dimension, Measure?
70.
What is Data warehosuing Hierarchy?
71.
Explain What are the steps to build the data warehouse?
72.
Explain ER Diagram?
73.
what is junk dimension?
what is the difference between junk dimension and degenerated dimension?
74.
Explain What are the different types of data warehousing?
75.
Explain Dimensional Modelling?
76.
Explain can a dimension table contains numeric values?
77.
Explain the difference between view and materialized view?
78.
Explain VLDB?
79.
Explain the data types present in bo n wht happens if we implement view in the designer n report?
80.
Explain What are the methodologies of Data Warehousing?
81.
Explain Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
82.
Explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
83.
Explain What is the main difference between Inmon and Kimball philosophies of data warehousing?
84.
Explain a linked cube?
85.
What is the main difference between schema in RDBMS and schemas in DataWarehouse?
86.
What is static and local variable?
87.
What is metadata in context of a Datawarehouse and how it is important?
88.
Suggest a good author for Hyperion in data warehousing?
89.
What is incremintal loading?
What is batch processing?
What is crass reference table?
What is aggregate fact table?
90.
What is the datatype of the surrogate key?
91.
What is surrogate key? where we use it explain with example?
92.
Explain the definition of normalized and denormalized view and what are the differences between them?
93.
Explain What are the vaious ETL tools in the Market?
94.
What are the Data Marts?
95.
What is mean by aggregate aware?
How we are using this function?
96.
what are templates in which way it is help full?
what is data provider?
what is freehand sql?
difference between b.o 5.1 and 6.1b?
97.
We want to restrict top 26 rows ... in report
is there any rownum object from which we can do this?
98.
What are steps we have to follow in designing the userfriendly Universe?
99.
How can we acheive Correlated sub-query in Designer?can anyone help me in this regard?
100.
What is index awareness in universe?
101.
What are the steps to taken care to improve the Report performance?
102.
How will you know the version of Bo using designer?
103.
What is the Functional & Architectural Differences between Business Objects and Web Intelligence Reports?
104.
Which command using Query Analyzer will give you the version of SQL server and operating system?
105.
Could any one explain me how to create cascading prompts?
106.
What is slicing and dicing in business objects?
107.
What is pragma?
108.
How to link two different universes?
109.
How to Implement the the Built-in Strategy Script in BO Designer?
110.
What is is the Guidelines to Build Universe with Better Performance? R Performance tuning Issues of Universes?
111.
I need to set predefined condition. How I do this?
112.
What is the difference in creating filters in Designer and Business Objects?
113.
How to create Context?
114.
What are the security level used in BO?
115.
How to create Universe using Flat file in BO6.0?
116.
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
Database in use is Oracle?
117.
Explain in Detail abt Measure Objects? and what is the use of it? How to create it?
118.
What are Universe requirements?
119.
How do we design a universe?
120.
Let me know the things we can do in WEBi and cannot do it in FULL CLIENT and vice verse for BO6.5?
121.
Explain Are Data mart and DWH normalized or denormalized? Do both of them exist in
the same tier?
122.
Explain How to schedule the report in B.O?
123.
Explain When to use local filter and when to use global Filter?
124.
Explain What is the difference between slice and dice and cross tab report?
125.
Explain How can we do load testing for Webi Reports? (Example if I have have to test one webi report for Concurrent users refreshing report at one time)?
126.
What is the difference between BoXIR2 and BOXIR3?
127.
What is the difference between User And versatile user?
128.
What are all difference between business objects 6.5 and XI R2?
129.
What is difference between Webi and Infoview?
130.
What is a fantrap in Business Objects?
131.
Give some information on REPORT BURSTING and how to do it in BCA as i have to split the report and send diff reports to diff people?
132.
Explain the difference between compatible and incompatible objects?
133.
What is a bo repository?
134.
What is the dense rank?
135.
Explain Is there any default username & pwd for BO designer & supervisor?
136.
What is difference between custom hierarchy and report based hierarchy?
137.
Explain What would you consider as your biggest achievement and why?
138.
Explain the difference between detect alias and detect context?
139.
What is the difference between condition & filter?
140.
What is Object Stores?
141.
Explain How we drill up week to Month?
142.
Explain When we use aggregate awareness function in designer?
143.
How to generate the report from excel sheet?
144.
What is thumbnail?
145.
What is report template in B.O?
146.
What are the steps to be taken to schedule the report?
147.
Explain How many universes can be created in a project?
148.
Explain about Alerts in Bos, Under what situation we need to use alerts?
149.
Explain What are the steps to do to use Alerts in BO?
150.
What is a derived table in data warehousing?
151.
Explain Is there any tool that can compare two Unvs / two Rpts , built using BO 5.1 / BO 6.5?
152.
Explain is there any other repository domains rather than universe, security, document?
153.
Explain Difference between ZABO and webi?
154.
Explain What three things do you consider to be the most important factors for a manager?
155.
Explain How to execute the plsql procedure from the report by clicking with mouse?
156.
Explain What are the steps to be taken to schedule the report?
157.
If I have three predefined prompts.In a report it will come randomly.How they will come in a specified format?
158.
What is top business?
159.
Explain the difference between union and group?
160.
Explain What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
161.
Explain Which versions are used in the BO dashboard work?
162.
How can we create a dynamic column name in Cognos?
163.
What is Cognos Powerhouse and what is it used for?
164.
What is the difference b/w macros and prompt?
165.
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? is it possible, if so how?
166.
What is meant by Junk Dimension?
167.
In my report contain Product name, Amount, Country, Sales person.
I want to create one prompt: Sales Territory.( Ex: asia, US, UK, AUS), but territory column is not there in my model and source.
if u select the Asia in prompt page-ll Asian country results I want in report page.
I discussed with my friends and colleague, they told use the static choice function.
Still I face this problem. if u know please tell me?
168.
How to crate cubes in transformer?
169.
What is catalog and types of catalogs in cagonos and which is better?
170.
What Junk Dimension contains?
171.
Please explain the different stages in creating a report in cognos report net?
172.
What is the difference between a cascading report and drillthru report?why do we go for drill thru report?
173.
What is drill down and slicing and dicing whats the difference between them?
174.
Give me any example of semi and non additive measures?
175.
What is difference between PAGE BREAK and Section Report?

What is Main Advantage Datawarehousing over Oracle?
176.
What is Zero-foot print?
What are the other methods working as deployment functionality?
177.
How you drill from powerPLay to Impromptu? Explain all Steps?
178.
What is the difference between enterprise data warehouse and data warehouse?
179.
what is meant by alternate drill down with ex?
180.
How create measures and Demensions?
181.
What is loop in frameworkmanager?
182.
What you mean by Drill across and what is the difference between drill through, drill across?
183.
How do add dynamic titles in PP?
184.
What is the difference between group and associare?
185.
What is Cognos Visualizer and Cognos Scripting?
186.
How can create users and permissions in cognos?
187.
How can i schedule reports in cognos?
188.
How can i test reports in cagonos?
189.
What are products of cognos?
190.
Difference between Cold fusion MX 6 and Cold fusion MX 7?
191.
What is Application.cfm?
192.
Can we have multiple Application.cfm file in an Application?
193.
What is the difference between absolute and relative div positioning?
194.
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
195.
How would you format some text using css to be verdana and bold?
196.
What is the working process for Application.cfm?
197.
What is cfapplication tag?
198.
How can you set the Client Management?
199.
How can you set the Session Management?
200.
What are Session Timeout and Application Timeout? Where we have to do this process?
201.
How can you clear the cache?
202.
What are the advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?
203.
How would you write a simple stored procedure in TSQL which takes a movie_id and returns all the directors associated with it?
204.
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the LEFT JOIN query?
205.
How would you write a LEFT JOIN statement to return a result set of movie.title�s and director.name�s?
206.
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
207.
Explain the structure of Cold fusion?
208.
What is Web Server?
209.
What is Application Server?
210.
How can you communicate with web server (Apache or IIS) from Coldfusion?
211.
What are the advantages of Cold fusion?
212.
Compare Cold fusion with other programming languages?
213.
Difference between Cold fusion 5 and Cold fusion MX 6?
214.
Is it possible to design report layout in crystal reports without Database info?
215.
How can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema?
216.
How to performance tune reports?
217.
What is the difference between running total and sub-total?
218.
How to know the time taken for particular report execution?
219.
How to create diff. types of templates?
220.
Can we stop the database null values? How?
221.
What is the section expert? Why we use it?
222.
How can we change the Hierarchi of group? and for parameter also?
223.
How many types of subreport are there?
224.
In one subreport how many subreport we can insert?
225.
What is subreport? In one report maximum how many subreport we can insert?
226.
How many different types of reports we can create in Crystal reports?
227.
What is OLAP grid? Where it is used?
228.
What are the advantages or disadvantages of using Crystal Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control?
229.
How to "Print" in Crystal Reports while using ASP DOT NET Platform?
230.
Can we use Crystal report as a stand-alone application?
231.
How do we format field?
How do we connect to the database?
232.
Can we export data of reports into other format like in world doc etc?
233.
Can we create report using more than one database?
234.
Can we use our own SQL for creating a report?
235.
What are the sections that we have in Crystal reports?
236.
Can we add any database field once we have chosen Close button?
237.
Can we use stored procedure for creating the report?
238.
Does Crystal Report support all the functions that we have in Oracle?
239.
What is caching? What are the different types of caching?
240.
Is there any feature like summing total in crystal report?
241.
What is data mart?
242.
Explain What is data validation strategies for data mart validation after loading process?
243.
What is data validation strategies for data mart v?
244.
What is the definitions for Datawarehose and Datamart?
245.
What is difference between drill & scope of analysis?
246.
Explain Meta data?
247.
Explain What are Data Marts?
248.
Explain What is type 2 version dimension?
249.
Explain difference between data ware house & data mart?
250.
What we will do with the Universe for faster process?
251.
What is the difference between a data warehouse and a data mart?
252.
What is data warehousing?
253.
What is ETL process in data warehousing?
254.
What is data mining?
255.
What is BCP?
256.
What is DTS in SQL Server?
257.
What is bulk insert?
258.
What is DTS?
259.
What is OLTP?
260.
What is an OLAP?
261.
What is conceptual, logical and physical model?
262.
What is data purging?
263.
What are cubes?
264.
What are the primary ways to store data in OLAP?
265.
What is multi-dimensional analysis?
266.
What is MDX?
267.
What is discrete and continuous data in data mining world?
268.
What is model is data mining?
269.
What is a decision tree algorithm?
270.
What is naive bayes algorithm?
271.
Explain clustering algorithm?
272.
Explain in detail neural networks?
273.
What is back propagation in neural networks?
274.
What is time series algorithm in data mining?
275.
Is there any possibility to generate alphanumeric surrogate key?
276.
How to enter a log in auditing table whenever a job get finished?
277.
What is audit table?
278.
How to add zero "0" before record in a field?
279.
How to get the unique records on multiple columns by using sequential file stage only?
280.
If a column contains data like
abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,roy,pwe,aaa,xxx,xyz,roy,xok....
how to send the unique data to one source and remaining data to another source?
281.
If a column contains data like
ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
282.
How to design file watch jobs?
283.
How to remove blank spaces from data?
284.
What is Cleanup Resources and when do you use it?
285.
How to reduce warnings?
286.
Explain What is a View as it relates to system modeling?
287.
Explain What is analytical or analytic mean?
288.
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
289.
Explain What is Cost Benefit Analysis (CBA)?
290.
What is the 4 + 1 View Model as it relates to system modeling?
291.
Explain Have you ever been in a real dilemma at work? What did you do to get out of it?
292.
What is your spectra photometer working principles?
293.
Explain What is the difference between a Primary and Secondary Actor in Use Case Modeling?
294.
Explain about a task that really tested your analytical abilities?
295.
Explain Is it the job of a business analyst or systems analyst to draw the class diagram?
296.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
297.
Explain What sort of existing documents should Business Analysts refer to when starting on a new project?
298.
Explain What task is 98% of the required work of a Business Analyst?
299.
What is a Data Warehouse?
300.
Explain Which are the OLAP tools available that are supported by Oracle?
301.
Explain about a time when you discovered a more efficient way to do a work task?
302.
Explain SWOT Analysis?
303.
Explain about a tricky situation for which you found a very simple solution?
304.
Suppose I am loaded with questions as I am an experienced ETL coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of NON EMPTY so that I dont see records that are blank.?
305.
Explain What is the difference between Business Requirement Document and Use case Document. What is the difference.

I need a good BRD and UC template?
306.
Explain As a BA (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
307.
Explain What is the difference between OLAP and datawarehosue?
308.
Explain What are non-additive facts in detail?
309.
What is cubes?
310.
Explain Why Denormalization is promoted in Universe Designing?
311.
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
312.
Explain What is fact less fact table? where you have used it in your project?
313.
Explain what is aggregate table and aggregate fact table ... any examples of both?
314.
Please explain in detail about
type 1,
type 2(SCD),
type 3?
315.
Where the applications and where
ware house management system is used?
316.
What is snapshot?
317.
What is active data warehousing?
318.
What is the difference between datawarehouse and BI?
319.
Explain Is OLAP databases are called decision support system true/false?
320.
Explain What is the difference between datawarehouse and BI?
321.
What is the difference between Datawarehousing and BusinessIntelligence?
322.
What is the difference between ODS and OLTP?
323.
In Microstrategy, how can we direct the sql generated to use a specifc table?

I know of using ApplySimple, but there are other ways too?
324.
Explain What is the difference between view filter and report filter?
325.
What are Logical Views used for In Microstrategy?
326.
Explain What is the Difference b/w Microstrategy and cognos Reporting Tool?
327.
Explain What are the different types of JOIN operations?
328.
What is Smart Metric?
329.
What is Meta data?
330.
Briefly state different between data ware house & data mart?
331.
What is galaxy schema?
332.
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition.
333.
After we create a SCD table, can we use that particular Dimension as a dimension table for Star Schema?
334.
What is Core Dimension?
335.
How much data hold in one universe.
336.
Can any one explain about Core Dimension, Balanced Dimension, and Dirty Dimension?
337.
Can any one explain the Hierarchies level Data warehousing.
338.
What is data cleaning? How can we do that?
339.
What is dimension modeling?
340.
Where the cache files stored?
341.
How can you import tables from a database?
342.
What is drilling across?
343.
How Many different schemas or DW Models can be used in Siebel Analytics. I know Only STAR and SNOW FLAKE and any other model that can be used?
344.
What is an error log table in Informatica occurs and how to maintain it in mapping?
345.
What is loop in Data warehousing?
346.
How many clustered indexes can u create for a table in DWH? In case of truncate and delete command what happens to table, which has unique id.
347.
What is hybrid slowly changing dimension?
348.
Can a dimension table contain numeric values?
349.
How do you create Surrogate Key using Ab Initio?
350.
What is the difference between star and snowflake schemas?
351.
What is a CUBE in data warehousing concept?
352.
What is the difference between Snowflake and Star Schema? What are situations where Snowflake Schema is better than Star Schema when the opposite is true?
353.
What is ER Diagram?
354.
What is degenerate dimension table?
355.
What is VLDB?
356.
What is Dimensional Modeling?
357.
What are the various ETL tools in the Market?
358.
What are the possible data marts in Retail sales?
359.
What is meant by metadata in context of a Data warehouse and how it is important?
360.
What is a linked cube?
361.
What is surrogate key? Where we use it? Explain with examples.
362.
What are the data types present in BO? What happens if we implement view in the designer n report?
363.
What are data validation strategies for data mart validation after loading process?
364.
What is Data warehousing Hierarchy?
365.
What is BUS Schema?
366.
What are the methodologies of Data Warehousing?
367.
What is conformed fact?
368.
What is Difference between E-R Modeling and Dimensional Modeling?
369.
Why fact table is in normal form?
370.
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
371.
What is the main difference between Inmon and Kimball philosophies of data warehousing?
372.
What is the difference between view and materialized view?
373.
What is the advantages data mining over traditional approaches?
374.
Explain What is the data type of the surrogate key?
375.
What a static and local variable?
376.
What is data type of the surrogate key?
377.
Explain difference between view and materialized view?
378.
Explain the main difference between Inmon and Kimball philosophies of data warehousing?
379.
Why fact table is in a normal form?
380.
Explain What are Fact, Dimension, and Measure?
381.
Explain What is a cube in data warehousing concept?
382.
Explain the different types of data warehousing?
383.
What are the main steps to build the data warehouse?
384.
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
385.
Explain the main differences between star and snowflake schema?
386.
Explain What is the advantages data mining over traditional approaches?
387.
How to use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
388.
Explain What is partitioning? What are the types of partitioning?
389.
Explain Do we need an ETL tool? When do we go for the tools in the market?
390.
Explain What is Informatica Metadata and where is it stored?
391.
Explain What is ETL process ?How many steps ETL contains explain with example?
392.
How to call shell scripts from informatica?
393.
Explain What is the metadata extension?
394.
Explain Is there any way to read the MS Excel Datas directly into Informatica?Like IS there any Possibilities to take excel file as target?
395.
Explain What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
396.
Tell me can we override a native sql query within Informatica? Where do we do it? How do we do it?
397.
Explain What are the various methods of getting incremental records or delta records from the source systems?
398.
Explain What is a staging area? Do we need it? What is the purpose of a staging area?
399.
Explain What is Full load & Incremental or Refresh load?
400.
Explain a mapping, session, worklet, workflow, mapplet?
401.
Tell me what is Full load & Incremental or Refresh load?
402.
Explain What is a three tier data warehouse?
403.
Explain What is the difference between Power Center & Power Mart?
404.
Explain Where do we use semi and non additive facts?
405.
How can we determine what records to extract?
406.
Explain the different Lookup methods used in Informatica?
407.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA?
408.
Explain the difference between keylokup and joiner?
409.
Explain and Compare ETL & Manual development?
410.
Explain When do we Analyze the tables? How do we do it?
411.
Suppose we have some 10,000 odd records in source system and when load them into target.How do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
412.
Explain What are the different versions of Informatica?
413.
Explain Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)?
414.
Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?
415.
Explain What are the various transformation available?
416.
Explain the difference between etl tool and olap tools?
417.
How to extract SAP data Using Informatica? What is ABAP? What are IDOCS?
418.
Explain What are the modules in Power Mart?
419.
How to calculate fact table granularity?
420.
What is latest version of Power Center / Power Mart?
421.
What are the various tools? Explain Name a few?
422.
Explain if a flat file cotains 1000 records how can i get first and last records only?
423.
Explain What is ODS (operation data source)?
424.
What is Normalization, First Normal Form, Second Normal Form, Third Normal Form?
425.
Explain piconet?
426.
Explain What are the Different methods of loading Dimension tables?
427.
What is ODS?
428.
Explain me What are Data Marts?
429.
What is a level of Granularity of a fact table?
430.
Explain me what is VLDB?
431.
What is SCD1 , SCD2 , SCD3?
432.
Explain What is What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
433.
Explain ssl?
434.
Explain What are the various Reporting tools in the Market?
435.
Explain the Difference between OLTP and OLAP?
436.
What is Snow Flake Schema?
437.
What is a lookup table?
438.
What is the Differences between star and snowflake schemas?
439.
Explain What is real time data-warehousing?
440.
What are vaious ETL tools in the Market?
441.
What is pre-emptive and non-pre-emptive?
442.
Explain What type of Indexing mechanism do we need to use for a typical datawarehouse?
443.
What are the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs?
444.
What are modeling tools available in the Market?
445.
What is data mining?
446.
Explain What are slowly changing dimensions?
447.
What is is a Star Schema?
448.
Explain Which columns go to the fact table and which columns go the dimension table?
449.
What is a dimension table?
450.
Explain How are the Dimension tables designed?
451.
What is a general purpose scheduling tool?
452.
List down some of the real time data-warehousing tools?
453.
Explain Why should you put your data warehouse on a different system than your OLTP system?
454.
What is an ER Diagram?
455.
Explain some of modeling tools available in the Market?
456.
Explain What are non-additive facts?
457.
What is a data warehousing?
458.
What is a Fact table?
459.
Explain What does level of Granularity of a fact table signify?
460.
Explain What are conformed dimensions?
461.
Explain Why are OLTP database designs not generally a good idea for a Data Warehouse?
462.
How to load the time dimension?
463.
Explain me what are conformed dimensions?
464.
What does dependency analysis mean in Ab Initio?
465.
When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
466.
Describe the Grant/Revoke DDL facility and how it is implemented?
467.
What is the difference between rollup and scan?
468.
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
469.
How can i run the 2 GUI merge files?
470.
Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e.: a test and production copy of a database)?
471.
How would you find out whether a SQL query is using the indices you expect?
472.
How to create repository in abinitio for stand alone system(LOCAL NT)?
473.
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
474.
Explain the difference between the truncate and delete commands?
475.
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
476.
How can you force the optimizer to use a particular index?
477.
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
478.
Why might you create a stored procedure with the with recompile option?
479.
What is the purpose of having stored procedures in a database?
480.
What are Cartesian joins?
481.
What is an outer join?
482.
What are primary keys and foreign keys?
483.
Have you used rollup component? Describe how?
484.
How do you convert 4-way MFS to 8-way mfs?
485.
What is AB_LOCAL expression where do you use it in ab-initio?
486.
What is the latest version that is available in Ab-initio?
487.
What is $mpjret? Where it is used in ab-initio?
488.
I am unable to connect sever database(oracle) from GDE(db config file) local system.i set all these?
489.
What is the Difference between DML Expression and XFR Expression?
490.
How Does MAXCORE works?
491.
What is the syntax of m_dump command?
492.
Can anyone give me an exaple of realtime start script in the graph?
493.
What are differences between different GDE versions(1.10,1.11,1.12,1.13and 1.15)?
What are differences between different versions of Co-op?
494.
How to run the graph without GDE?
495.
What is local and formal parameter?
496.
What is BRODCASTING and REPLICATE?
497.
What is the importance of EME in abinitio?
498.
What is m_dump?
499.
What is the difference between a Scan component and a RollUp component?
500.
What is skew and skew measurement?
501.
How to get DML using Utilities in UNIX?
502.
Explain Difference between onRow and Onread method?
503.
How do we have left -right flow , normally its top-down flow?
504.
What property you use to Hide a control at runtime?
505.
We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?
506.
I generated one report design time i
can color green. at run i want bule how to change dynamically? and which method i can over write?
507.
What is AFC? Where we Use AFC in Actuate?
508.
What is the filter?
509.
How to call a stored procedure from a report?
510.
Connecting to iServer Volume using IDAPI
Classes(Java Classes) and after connecting to iServer i want to execute the ROX on iServer and also want know the status whether that job
is succesfully run or not?
511.
How many times executite the fetch method at run time?
512.
What is data stream and data adaopter is it same are different? explain?
513.
How to implement the parallel report?
514.
How to generate a report by getting values from two reports. the generated report should contain the 5 values of first report and last 5 values of second report?
515.
What is the difference between
-using Group by in the SQL of the report
-having a Group section in the report?
516.
Can we define global methods in a report?
517.
Can we connect to 2 different types of database through the same report?
518.
What is report bursting?
519.
What is page level security?
520.
Which cmponent has onRead method and what it is used for?
521.
Explain Differences between star and snowflake schemas?
522.
Explain the data type of the surrogate key?
523.
What is a CUBE in datawarehousing concept?
524.
Explain Why fact table is in normal form?
525.
Explain What are the possible data marts in Retail sales?
526.
Explain degenerate dimension table?
527.
Explain hybrid slowly changing dimension?
528.
Explain conformed fact?
529.
Explain BUS Schema?
530.
Explain What are the advantages data mining over traditional approaches?
531.
Explain Difference between E-R Modeling and Dimentional Modeling?
532.
What is a Fact, Dimension, Measure?
533.
What is Data warehosuing Hierarchy?
534.
Explain What are the steps to build the data warehouse?
535.
Explain ER Diagram?
536.
what is junk dimension?
what is the difference between junk dimension and degenerated dimension?
537.
Explain What are the different types of data warehousing?
538.
Explain Dimensional Modelling?
539.
Explain can a dimension table contains numeric values?
540.
Explain the difference between view and materialized view?
541.
Explain VLDB?
542.
Explain the data types present in bo n wht happens if we implement view in the designer n report?
543.
Explain What are the methodologies of Data Warehousing?
544.
Explain Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
545.
Explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
546.
Explain What is the main difference between Inmon and Kimball philosophies of data warehousing?
547.
Explain a linked cube?
548.
What is the main difference between schema in RDBMS and schemas in DataWarehouse?
549.
What is static and local variable?
550.
What is metadata in context of a Datawarehouse and how it is important?
551.
Suggest a good author for Hyperion in data warehousing?
552.
What is incremintal loading?
What is batch processing?
What is crass reference table?
What is aggregate fact table?
553.
What is the datatype of the surrogate key?
554.
What is surrogate key? where we use it explain with example?
555.
Explain the definition of normalized and denormalized view and what are the differences between them?
556.
Explain What are the vaious ETL tools in the Market?
557.
What are the Data Marts?
558.
What is mean by aggregate aware?
How we are using this function?
559.
what are templates in which way it is help full?
what is data provider?
what is freehand sql?
difference between b.o 5.1 and 6.1b?
560.
We want to restrict top 26 rows ... in report
is there any rownum object from which we can do this?
561.
What are steps we have to follow in designing the userfriendly Universe?
562.
How can we acheive Correlated sub-query in Designer?can anyone help me in this regard?
563.
What is index awareness in universe?
564.
What are the steps to taken care to improve the Report performance?
565.
How will you know the version of Bo using designer?
566.
What is the Functional & Architectural Differences between Business Objects and Web Intelligence Reports?
567.
Which command using Query Analyzer will give you the version of SQL server and operating system?
568.
Could any one explain me how to create cascading prompts?
569.
What is slicing and dicing in business objects?
570.
What is pragma?
571.
How to link two different universes?
572.
How to Implement the the Built-in Strategy Script in BO Designer?
573.
What is is the Guidelines to Build Universe with Better Performance? R Performance tuning Issues of Universes?
574.
I need to set predefined condition. How I do this?
575.
What is the difference in creating filters in Designer and Business Objects?
576.
How to create Context?
577.
What are the security level used in BO?
578.
How to create Universe using Flat file in BO6.0?
579.
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
Database in use is Oracle?
580.
Explain in Detail abt Measure Objects? and what is the use of it? How to create it?
581.
What are Universe requirements?
582.
How do we design a universe?
583.
Let me know the things we can do in WEBi and cannot do it in FULL CLIENT and vice verse for BO6.5?
584.
Explain Are Data mart and DWH normalized or denormalized? Do both of them exist in
the same tier?
585.
Explain How to schedule the report in B.O?
586.
Explain When to use local filter and when to use global Filter?
587.
Explain What is the difference between slice and dice and cross tab report?
588.
Explain How can we do load testing for Webi Reports? (Example if I have have to test one webi report for Concurrent users refreshing report at one time)?
589.
What is the difference between BoXIR2 and BOXIR3?
590.
What is the difference between User And versatile user?
591.
What are all difference between business objects 6.5 and XI R2?
592.
What is difference between Webi and Infoview?
593.
What is a fantrap in Business Objects?
594.
Give some information on REPORT BURSTING and how to do it in BCA as i have to split the report and send diff reports to diff people?
595.
Explain the difference between compatible and incompatible objects?
596.
What is a bo repository?
597.
What is the dense rank?
598.
Explain Is there any default username & pwd for BO designer & supervisor?
599.
What is difference between custom hierarchy and report based hierarchy?
600.
Explain What would you consider as your biggest achievement and why?
601.
Explain the difference between detect alias and detect context?
602.
What is the difference between condition & filter?
603.
What is Object Stores?
604.
Explain How we drill up week to Month?
605.
Explain When we use aggregate awareness function in designer?
606.
How to generate the report from excel sheet?
607.
What is thumbnail?
608.
What is report template in B.O?
609.
What are the steps to be taken to schedule the report?
610.
Explain How many universes can be created in a project?
611.
Explain about Alerts in Bos, Under what situation we need to use alerts?
612.
Explain What are the steps to do to use Alerts in BO?
613.
What is a derived table in data warehousing?
614.
Explain Is there any tool that can compare two Unvs / two Rpts , built using BO 5.1 / BO 6.5?
615.
Explain is there any other repository domains rather than universe, security, document?
616.
Explain Difference between ZABO and webi?
617.
Explain What three things do you consider to be the most important factors for a manager?
618.
Explain How to execute the plsql procedure from the report by clicking with mouse?
619.
Explain What are the steps to be taken to schedule the report?
620.
If I have three predefined prompts.In a report it will come randomly.How they will come in a specified format?
621.
What is top business?
622.
Explain the difference between union and group?
623.
Explain What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
624.
Explain Which versions are used in the BO dashboard work?
625.
How can we create a dynamic column name in Cognos?
626.
What is Cognos Powerhouse and what is it used for?
627.
What is the difference b/w macros and prompt?
628.
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? is it possible, if so how?
629.
What is meant by Junk Dimension?
630.
In my report contain Product name, Amount, Country, Sales person.
I want to create one prompt: Sales Territory.( Ex: asia, US, UK, AUS), but territory column is not there in my model and source.
if u select the Asia in prompt page-ll Asian country results I want in report page.
I discussed with my friends and colleague, they told use the static choice function.
Still I face this problem. if u know please tell me?
631.
How to crate cubes in transformer?
632.
What is catalog and types of catalogs in cagonos and which is better?
633.
What Junk Dimension contains?
634.
Please explain the different stages in creating a report in cognos report net?
635.
What is the difference between a cascading report and drillthru report?why do we go for drill thru report?
636.
What is drill down and slicing and dicing whats the difference between them?
637.
Give me any example of semi and non additive measures?
638.
What is difference between PAGE BREAK and Section Report?

What is Main Advantage Datawarehousing over Oracle?
639.
What is Zero-foot print?
What are the other methods working as deployment functionality?
640.
How you drill from powerPLay to Impromptu? Explain all Steps?
641.
What is the difference between enterprise data warehouse and data warehouse?
642.
what is meant by alternate drill down with ex?
643.
How create measures and Demensions?
644.
What is loop in frameworkmanager?
645.
What you mean by Drill across and what is the difference between drill through, drill across?
646.
How do add dynamic titles in PP?
647.
What is the difference between group and associare?
648.
What is Cognos Visualizer and Cognos Scripting?
649.
How can create users and permissions in cognos?
650.
How can i schedule reports in cognos?
651.
How can i test reports in cagonos?
652.
What are products of cognos?
653.
Difference between Cold fusion MX 6 and Cold fusion MX 7?
654.
What is Application.cfm?
655.
Can we have multiple Application.cfm file in an Application?
656.
What is the difference between absolute and relative div positioning?
657.
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
658.
How would you format some text using css to be verdana and bold?
659.
What is the working process for Application.cfm?
660.
What is cfapplication tag?
661.
How can you set the Client Management?
662.
How can you set the Session Management?
663.
What are Session Timeout and Application Timeout? Where we have to do this process?
664.
How can you clear the cache?
665.
What are the advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?
666.
How would you write a simple stored procedure in TSQL which takes a movie_id and returns all the directors associated with it?
667.
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the LEFT JOIN query?
668.
How would you write a LEFT JOIN statement to return a result set of movie.title�s and director.name�s?
669.
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
670.
Explain the structure of Cold fusion?
671.
What is Web Server?
672.
What is Application Server?
673.
How can you communicate with web server (Apache or IIS) from Coldfusion?
674.
What are the advantages of Cold fusion?
675.
Compare Cold fusion with other programming languages?
676.
Difference between Cold fusion 5 and Cold fusion MX 6?
677.
Is it possible to design report layout in crystal reports without Database info?
678.
How can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema?
679.
How to performance tune reports?
680.
What is the difference between running total and sub-total?
681.
How to know the time taken for particular report execution?
682.
How to create diff. types of templates?
683.
Can we stop the database null values? How?
684.
What is the section expert? Why we use it?
685.
How can we change the Hierarchi of group? and for parameter also?
686.
How many types of subreport are there?
687.
In one subreport how many subreport we can insert?
688.
What is subreport? In one report maximum how many subreport we can insert?
689.
How many different types of reports we can create in Crystal reports?
690.
What is OLAP grid? Where it is used?
691.
What are the advantages or disadvantages of using Crystal Reports in a Windows Forms application as opposed to say rolling our own reports as HTML and displaying them in the Internet Explorer control?
692.
How to "Print" in Crystal Reports while using ASP DOT NET Platform?
693.
Can we use Crystal report as a stand-alone application?
694.
How do we format field?
How do we connect to the database?
695.
Can we export data of reports into other format like in world doc etc?
696.
Can we create report using more than one database?
697.
Can we use our own SQL for creating a report?
698.
What are the sections that we have in Crystal reports?
699.
Can we add any database field once we have chosen Close button?
700.
Can we use stored procedure for creating the report?
701.
Does Crystal Report support all the functions that we have in Oracle?
702.
What is caching? What are the different types of caching?
703.
Is there any feature like summing total in crystal report?
704.
What is data mart?
705.
Explain What is data validation strategies for data mart validation after loading process?
706.
What is data validation strategies for data mart v?
707.
What is the definitions for Datawarehose and Datamart?
708.
What is difference between drill & scope of analysis?
709.
Explain Meta data?
710.
Explain What are Data Marts?
711.
Explain What is type 2 version dimension?
712.
Explain difference between data ware house & data mart?
713.
What we will do with the Universe for faster process?
714.
What is the difference between a data warehouse and a data mart?
715.
What is data warehousing?
716.
What is ETL process in data warehousing?
717.
What is data mining?
718.
What is BCP?
719.
What is DTS in SQL Server?
720.
What is bulk insert?
721.
What is DTS?
722.
What is OLTP?
723.
What is an OLAP?
724.
What is conceptual, logical and physical model?
725.
What is data purging?
726.
What are cubes?
727.
What are the primary ways to store data in OLAP?
728.
What is multi-dimensional analysis?
729.
What is MDX?
730.
What is discrete and continuous data in data mining world?
731.
What is model is data mining?
732.
What is a decision tree algorithm?
733.
What is naive bayes algorithm?
734.
Explain clustering algorithm?
735.
Explain in detail neural networks?
736.
What is back propagation in neural networks?
737.
What is time series algorithm in data mining?
738.
Is there any possibility to generate alphanumeric surrogate key?
739.
How to enter a log in auditing table whenever a job get finished?
740.
What is audit table?
741.
How to add zero "0" before record in a field?
742.
How to get the unique records on multiple columns by using sequential file stage only?
743.
If a column contains data like
abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,roy,pwe,aaa,xxx,xyz,roy,xok....
how to send the unique data to one source and remaining data to another source?
744.
If a column contains data like
ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
745.
How to design file watch jobs?
746.
How to remove blank spaces from data?
747.
What is Cleanup Resources and when do you use it?
748.
How to reduce warnings?
749.
Explain What is a View as it relates to system modeling?
750.
Explain What is analytical or analytic mean?
751.
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
752.
Explain What is Cost Benefit Analysis (CBA)?
753.
What is the 4 + 1 View Model as it relates to system modeling?
754.
Explain Have you ever been in a real dilemma at work? What did you do to get out of it?
755.
What is your spectra photometer working principles?
756.
Explain What is the difference between a Primary and Secondary Actor in Use Case Modeling?
757.
Explain about a task that really tested your analytical abilities?
758.
Explain Is it the job of a business analyst or systems analyst to draw the class diagram?
759.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
760.
Explain What sort of existing documents should Business Analysts refer to when starting on a new project?
761.
Explain What task is 98% of the required work of a Business Analyst?
762.
What is a Data Warehouse?
763.
Explain Which are the OLAP tools available that are supported by Oracle?
764.
Explain about a time when you discovered a more efficient way to do a work task?
765.
Explain SWOT Analysis?
766.
Explain about a tricky situation for which you found a very simple solution?
767.
Suppose I am loaded with questions as I am an experienced ETL coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of NON EMPTY so that I dont see records that are blank.?
768.
Explain What is the difference between Business Requirement Document and Use case Document. What is the difference.

I need a good BRD and UC template?
769.
Explain As a BA (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
770.
Explain What is the difference between OLAP and datawarehosue?
771.
Explain What are non-additive facts in detail?
772.
What is cubes?
773.
Explain Why Denormalization is promoted in Universe Designing?
774.
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
775.
Explain What is fact less fact table? where you have used it in your project?
776.
Explain what is aggregate table and aggregate fact table ... any examples of both?
777.
Please explain in detail about
type 1,
type 2(SCD),
type 3?
778.
Where the applications and where
ware house management system is used?
779.
What is snapshot?
780.
What is active data warehousing?
781.
What is the difference between datawarehouse and BI?
782.
Explain Is OLAP databases are called decision support system true/false?
783.
Explain What is the difference between datawarehouse and BI?
784.
What is the difference between Datawarehousing and BusinessIntelligence?
785.
What is the difference between ODS and OLTP?
786.
In Microstrategy, how can we direct the sql generated to use a specifc table?

I know of using ApplySimple, but there are other ways too?
787.
Explain What is the difference between view filter and report filter?
788.
What are Logical Views used for In Microstrategy?
789.
Explain What is the Difference b/w Microstrategy and cognos Reporting Tool?
790.
Explain What are the different types of JOIN operations?
791.
What is Smart Metric?
792.
Explain What is the data type of the surrogate key?
793.
What a static and local variable?
794.
What is data type of the surrogate key?
795.
Explain difference between view and materialized view?
796.
Explain the main difference between Inmon and Kimball philosophies of data warehousing?
797.
Why fact table is in a normal form?
798.
Explain What are Fact, Dimension, and Measure?
799.
Explain What is a cube in data warehousing concept?
800.
Explain the different types of data warehousing?
801.
What are the main steps to build the data warehouse?
802.
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
803.
Explain the main differences between star and snowflake schema?
804.
Explain What is the advantages data mining over traditional approaches?
805.
How to use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
806.
Explain What is partitioning? What are the types of partitioning?
807.
Explain Do we need an ETL tool? When do we go for the tools in the market?
808.
Explain What is Informatica Metadata and where is it stored?
809.
Explain What is ETL process ?How many steps ETL contains explain with example?
810.
How to call shell scripts from informatica?
811.
Explain What is the metadata extension?
812.
Explain Is there any way to read the MS Excel Datas directly into Informatica?Like IS there any Possibilities to take excel file as target?
813.
Explain What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
814.
Tell me can we override a native sql query within Informatica? Where do we do it? How do we do it?
815.
Explain What are the various methods of getting incremental records or delta records from the source systems?
816.
Explain What is a staging area? Do we need it? What is the purpose of a staging area?
817.
Explain What is Full load & Incremental or Refresh load?
818.
Explain a mapping, session, worklet, workflow, mapplet?
819.
Tell me what is Full load & Incremental or Refresh load?
820.
Explain What is a three tier data warehouse?
821.
Explain What is the difference between Power Center & Power Mart?
822.
Explain Where do we use semi and non additive facts?
823.
How can we determine what records to extract?
824.
Explain the different Lookup methods used in Informatica?
825.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA?
826.
Explain the difference between keylokup and joiner?
827.
Explain and Compare ETL & Manual development?
828.
Explain When do we Analyze the tables? How do we do it?
829.
Suppose we have some 10,000 odd records in source system and when load them into target.How do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
830.
Explain What are the different versions of Informatica?
831.
Explain Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)?
832.
Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?
833.
Explain What are the various transformation available?
834.
Explain the difference between etl tool and olap tools?
835.
How to extract SAP data Using Informatica? What is ABAP? What are IDOCS?
836.
Explain What are the modules in Power Mart?
837.
How to calculate fact table granularity?
838.
What is latest version of Power Center / Power Mart?
839.
What are the various tools? Explain Name a few?
840.
Explain if a flat file cotains 1000 records how can i get first and last records only?
841.
Explain What is ODS (operation data source)?
842.
What is Normalization, First Normal Form, Second Normal Form, Third Normal Form?
843.
Explain piconet?
844.
Explain What are the Different methods of loading Dimension tables?
845.
What is ODS?
846.
Explain me What are Data Marts?
847.
What is a level of Granularity of a fact table?
848.
Explain me what is VLDB?
849.
What is SCD1 , SCD2 , SCD3?
850.
Explain What is What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
851.
Explain ssl?
852.
Explain What are the various Reporting tools in the Market?
853.
Explain the Difference between OLTP and OLAP?
854.
What is Snow Flake Schema?
855.
What is a lookup table?
856.
What is the Differences between star and snowflake schemas?
857.
Explain What is real time data-warehousing?
858.
What are vaious ETL tools in the Market?
859.
What is pre-emptive and non-pre-emptive?
860.
Explain What type of Indexing mechanism do we need to use for a typical datawarehouse?
861.
What are the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs?
862.
What are modeling tools available in the Market?
863.
What is data mining?
864.
Explain What are slowly changing dimensions?
865.
What is is a Star Schema?
866.
Explain Which columns go to the fact table and which columns go the dimension table?
867.
What is a dimension table?
868.
Explain How are the Dimension tables designed?
869.
What is a general purpose scheduling tool?
870.
List down some of the real time data-warehousing tools?
871.
Explain Why should you put your data warehouse on a different system than your OLTP system?
872.
What is an ER Diagram?
873.
Explain some of modeling tools available in the Market?
874.
Explain What are non-additive facts?
875.
What is a data warehousing?
876.
What is a Fact table?
877.
Explain What does level of Granularity of a fact table signify?
878.
Explain What are conformed dimensions?
879.
Explain Why are OLTP database designs not generally a good idea for a Data Warehouse?
880.
How to load the time dimension?
881.
Explain me what are conformed dimensions?
882.
If two relational tables are connected to SQ Trans, what are the possible errors it will be thrown?
883.
What is a command that used to run a batch?
884.
How to stop a batch?
885.
What is EDW?
886.
What is the Difference between static cache and dynamic cache?
887.
Explain What is batch and describe about types of batches?
888.
Explain What are the tasks that Loadmanger process will do?
889.
Explain What is the limit to the number of sources and targets you can have in a mapping?
890.
What is Session and Batches?
891.
What is the difference between Power Center and Power Mart?

What is the procedure for creating Independent Data Marts from Informatica 7.1?
892.
Suppose if a session fails after loading of 10,000 records in to the target.How can you load the records from 10001 the record when you run the session next time?
893.
What are Aggregate transformation?
894.
What are the reusable transforamtions?
895.
Explain How many ways you create ports?
896.
What are Target Types on the Server?
897.
Why we use repository connectivity?
898.
Explain What are the mapping paramaters and maping variables?
899.
How to do unit testing in informatica?
How to load data in informatica ?
900.
How to handle decimal places while importing a flatfile into informatica?
901.
Explain the Differences between Normalizer and Normalizer transformation?
902.
What is the difference between Informatica 7.0 and 8.0?
903.
Explain How many types of dimensions are available in Informatica?
904.
Explain Where to store informatica rejected data? How to extract the informatica rejected data?
905.
How to configure mapping in informatica?
906.
What is the difference between informatics 7x and 8x and what is latest version?
907.
What is the difference between filter and lookup transformation?
908.
Explain How to import oracle sequence into Informatica?
909.
How to load time dimension?
910.
Explain What are the measure objects?
911.
Explain How to get the first 100 rows from the flat file into the target?
912.
Explain What are the basic needs to join two sources in a source qualifier?
913.
What is the use of incremental aggregation? Explain me in brief with an example?
914.
What are the joiner caches?
915.
Explain What is power center repository?
916.
Explain What is metadata reporter?
917.
What are the unsupported repository objects for a mapplet?
918.
How can we transform row to column?
919.
What is a time dimension? give an example?
920.
Explain Why dimenstion tables are denormalized in nature?
921.
How to load the data from people soft hrm to people soft erm using informatica?
922.
How to eliminate duplicate rows from flat file?
923.
Explain How to export mappings to the production environment?
924.
What is Recovering sessions?
925.
How Identifying bottlenecks in various components of Informatica and resolving them?
926.
What is perform recovery?
927.
What is the difference between connected and unconnected stored procedures?
928.
What are partition points?
929.
What is the difference between constraind base load ordering and target load plan?
930.
What is source qualifier transformation?
931.
Is union Transormation is Active transformation?
932.
What are variable ports and list two situations when they can be used?
933.
Whats the diff between Informatica powercenter server, repositoryserver and repository?
934.
How to import VSAM files from source to target. Do we need a special plugin?
935.
How many types of facts and what are they?
936.
Can we start and stop single session in concurent bstch?
937.
Start a batches with in a batch?
938.
Explain What are the different types of transformation available in informatica. and what are the mostly used ones among them?
939.
Explain Why we use partitioning the session in informatica?
940.
How to join 3 database like Flat File, Oracle, Db2 in Informatrica?
941.
Explain What is the difference between stop and abort?
942.
What is the Rankindex in Ranktransformation?
943.
What is Load Manager?
944.
How to improve session performance in aggregator transformation?
945.
What is the difference between Narmal load and Bulk load?
946.
Is it possible to see the data in dataset?
947.
What are the advantages of dataset compare to fileset?
948.
What are the nulls on microstrategy report and how to mask them?
949.
What is static prompt in microstrategy?
950.
What is view filter?
951.
How many project sources we can create in Metadata?
952.
What is Element cache and give me one example?
953.
How we can create the Intelligent cubes in Microstrategy?
954.
How to use consolidations in microstrategy report?
955.
In document how to create metrics?
956.
What is the difference b/w the public object&schema object?
957.
what is the difference between documents and dashboards in mstr?
958.
How to increase logical sige of a table in microstrategy?
959.
How to do performance tuning on reports?
960.
Difference between standard, absolute and ignore condition in metrics?
961.
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i do it and drag it onto report editor?
962.
How to use value prompt and drag it on to report editor?
963.
How to optimize a report in microstrategy environment?
964.
What are the roles & responsibilities of microstrategy developer?
965.
Is that possible to Insert and Update a record in the Database through Microstrategy?
966.
In Microstrategy, how can we direct the sql generated to use a specifc table?
967.
In Microstrategy, what are Logical Views used for?
968.
In Microstrategy, how can you direct the sql generated to use a specifc table?
969.
Explain normalization?
970.
Explain DDL (Data Definition Language)?
971.
Explain Functional Dependency?
972.
What is a functional dependency F said to be minimal?
973.
Explain a Relation Schema and a Relation?
974.
What is operational data store?
975.
What is a Relationship?
976.
Tell me what is degree of a Relation?
977.
Explain Multivalued dependency?
978.
What is VDL (View Definition Language) explain?
979.
Explain How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?
980.
How to drill through from a powerplay cube to reportnet?
981.
How to create prompts in report net?
982.
Explain What is difference between query studio and report studio?
983.
What is the Difference between PowerPlay transformer and power play reports?
984.
Explain What are components of report studio?
985.
Explain What are the advantages of query studio compared to report studio?
986.
How to generate the cubes in framework manager?
987.
Explain How to generate IQD file from framework manager?
988.
Explain Is there any comparison available for Cognos Reportnet Vs Crystal reports?
989.
Explain the difference between Native SQL and Cognos SQL?
990.
Suppose your client wants to ensure only specific users can create reports in Query Studio with other users creating reports using Report Studio. How can this be accomplished?
991.
Explain What are components of reportnet?
992.
How to provide security in frame work manager for a query subject?
993.
Explain What are the various file formats involved in reportnet?
994.
Explain the versions of reportnet?
995.
Explain the difference between DW and BI?
996.
What is prompt types of prompts?use of prompts syntax of prompt?
997.
Is Framework Manager an un-needed overhead? As we know Report Studio allows us to create the data model from a query and thereby skipping Framework Manager. Given that this feature is available, in what scenarios would one want to skip Framework Manager?
998.
Explain What is the Difference between PowerPlay transformer and power play reports?
999.
Explain What is the main advantage of impromptu over cognos reportnet?
1000.
How to test report in reportnet?
1001.
Explain What are necessary tasks to install reportnet software?
1002.
What function should we use to display the value entered or selected by a user in response to a prompt?
1003.
Explain Can report net connect multiple datasource at a time in report creation time?
1004.
Explain the difference between filter and conditin?
1005.
How to allow a dynamic selection of a column for a measure in a chart,without using Variable?
1006.
Explain What are the advantages and disadvantages of reporting directly against the database?

Do you always need to copy the data before reporting on it?(example, real-time & on-demand reporting is a requirement)?
1007.
What is difference between model & package?
1008.
Explain Wht is the extension of file to save template?
What is the difference between drill through and masterdetail reports?
1009.
How to define a cube??
1010.
Explain What is the difference between Native SQL and Cognos SQL?
1011.
How to limit the max no of rows retrieved in the report?
1012.
What is the use of tabular model, tabular SQL, tabular reference in real time application?
1013.
Suppose we want to display zero when null values coming to report how can we do that?
1014.
Suppose date is 05sep2005; i want the output like 05sep2005:00:00:00 ; how it will come?
1015.
What is option year cuttoff in sas?
1016.
How to CREATE an external dataset with sas code?
1017.
How to add a number to a macro variable?
1018.
Code the tables statement for a single-level (most common) frequency?
1019.
Code the tables statement to produce a multi-level frequency?
1020.
In PROC PRINT, can you print only variables that begin with the letter �A�?
1021.
Suppose a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like
100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
1022.
What is validvarname and varnum? why we are using this options; explain with a syntax for this options?
1023.
Suppose a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window. How can we do this one?
1024.
What is the use of catalog?
1025.
What is latest version of Power Center / Power Mart?
1026.
What is latest version of Power Center / Power Mart?
1027.
What is latest version of Power Center / Power Mart?
1028.
What is latest version of Power Center / Power Mart?