Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)
Crystal Enterprise Suite (30)
Actuate (46)
Ab Initio (442)
Data Stage (917)
SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)
IBM Cognos TM1 (55)
Amazon Redshift (62)
Data Warehouse General (749) Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?
2 10425Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
5 9104Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
3 14278here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
2 8022I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
IBM,
3 7224i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
2 7291
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What does sleep function does in fast load?
What is grain of fact?
What are target types on the server?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
what are passthrough functions?
How can we run the graph?
Have you ever encountered an error called “depth not equal”?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What is called Cognos powerplay?
Why is sorter an active transformation?
What is the command used to run a batch?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Explain what task is 98% of the required work of a business analyst?
Name the different types of Lookups in Datastage?