What is Micro Strategy? Why is it used for?
Answer Posted / chaitanya
Micro Strategy Architect is a rapid development tool that abstracts the organizational business model into a layered and reusable object-oriented centralized metadata by mapping physical data structures to Micro Strategy objects.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
tell me 5 session failure in real time how can you solve that in your project?
What is the reusable transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
How to convert multiple rows to single row (multiple columns) in informatica
What is union transformation?
What is sq transformation?
What are the different ways to implement parallel processing in informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is target designer and target load order?
what is diff b/t sorter t/r and agg have the option sorter property...
What is an expression transformation?
What are the features of complex mapping?
What is incremental aggregation?
What are batches?