Answer Posted / pranu
DSS database is optimized for running data queries that do not change the data. Since OLAP tools are used for analyzing data by running analytical queries, it is best to use DSS database
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Enlist the various types of transformations.
Is it possible to create multiple domains on a single Informatica server?
What are the tasks that source qualifier perform?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How do you convert single row from source into three rows into target?
How does the aggregator transformation handle null values?
Mention a few design and development best practices for informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is informatica?
What does refresh system mean, and what are its distinctive choice?
What are the components of workflow manager?
whats the logic to load the lower level of granularity of data to fact table.
What is meant by incremental aggregation?
What is powercenter on grid?