Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain lookup transformation in informatica
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How does the aggregator transformation handle null values?
can we override a native sql query within informatica? How do we do it?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to load a Dimension ? and how to load a fact table?
Explain what transformation and how many are there in informatica?
Can u generate reports in Informatica?
What are the different transaction levels available in transaction control transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is rank transformation in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
what is diff b/t sorter t/r and agg have the option sorter property...
What are the restrictions of union transformation?
