Interested to Buy Any Domain ? << Click Here >> for more details...
What is Micro Strategy? Why is it used for?
- 5 Answers
- 25531 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / l.b.
MicroStrategy is a business intelligence (BI), enterprise
reporting, and OLAP (on-line analytical processing)
software vendor.
| Is This Answer Correct ? | 26 Yes | 1 No |
Answer / srinivasarao
it is a bi tool for developing reports of company information by using database
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / 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 |
Answer / meeravali
MicroStrategy is a business intelligence (BI), enterprise
reporting, and OLAP (on-line analytical processing)
software vendor.
| Is This Answer Correct ? | 8 Yes | 4 No |
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
What are the different clients of powercenter?
Design a mapping to load a target table with the following values from the above source?
How might one distinguish in the case of mapping is right or not without associating session?
What are the reusable transforamtions?
How to extract sap data using informatica? What is abap? What are idocs?
what is lookupoverriding?
where to store informatica rejected data? How to extract the informatica rejected data?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
how to create user defined function (udf) in informatica
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
Explain how to import oracle sequence into informatica?
Teradata 
