In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
556What formatting can be applied to the information that is sent out by microstrategy narrowcast server?
547Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?
474If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?
588
Define bulk load mode?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the design features involved in teradata?
what is INFORMATICA TESTING process
Does AWS Redshift use SQL?
Differentiate between data file and descriptor file?
How create measures and demensions?
Which transformation we use to convert 'NA' to 'Not Available'
What is the use of stop statement?
difference between informatica 8.1.1 and 8.6
1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what are the facilities provided by data warehouse to analytical users?
Explain what is the difference between view filter and report filter?