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) Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
CTS,
2 8986Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
1995LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
6 22695In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
1 4730data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat
2 5511The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports
1 3846How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
3 289181) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment
3 11011
Explain what is metadata reporter?
what is the use of materialized view?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What can you learn from the SAS log when debugging?
How substr function works in sas?
What are the types of caches in lookup? Explain them.
List out some of the primary characteristics of teradata.
Have you ever encountered an error called “depth not equal”?
differentiate between power play transformer and power play reports?
Explain load alternative records / rows into multiple targets - informatica
What is the report studio?
Mention what information does a .dbc file extension provides to connect to the database?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
what is the meant by Normalization and de-normalization?
How will you execute direct sql in obiee?