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) what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
1 6781How to copy 1 million records from one DB to another, Which is effective interms of performance?
4 12334What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
TCS,
5 20020what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
1 5244How many universes are required for a single project,and how many reports are required for a single Universe.
2 6477Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
L&T,
18 35732what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
2510
In which transformation you cannot drag ports into it?
What is the function of surrogate key in data warehousing?
How is MLOAD Teradata Server restarted after execution?
what is stitch query in reportnet?
how do you use tm1 cubes in framework manager?
What is the difference between the local container and shared container?
Is Redshift a row based storage or columnar based?
How do you specify the number of iterations and specific condition within a single do loop?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
what is the difference between floor and ceil functions in sas? : Sas-administrator
What are intelligent cubes?
What is the difference between datastage and informatica?
where are dashboard components are created and maintained? : Sas-bi
What is report as filter in microstrategy?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.