I know of using applysimple, but there are other ways too?
Answer / Pawan Gill
Yes, there are other ways to perform transformations in a data warehouse besides ApplySimple. Some examples include SQL scripts (using Transact-SQL or HiveQL), UDFs (User Defined Functions), and ETL tools like Informatica, Talend, and Pentaho.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is operational data source (ODS)?
What is analytical or analytic mean?
DWH architecture?
What is MDX?
Explain what are components of report studio?
Which columns go to the fact table and which columns go the dimension table?
Can you state some of the innovations throughout history?
What are vaious etl tools in the market?
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends
What are the types of partitioning?
After the complete generation of a report who will test the report and who will analyze it?
What is DTM session?