I know of using applysimple, but there are other ways too?



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

Post New Answer

More Data Warehouse General Interview Questions

What is operational data source (ODS)?

2 Answers  


What is analytical or analytic mean?

1 Answers  


DWH architecture?

6 Answers  


What is MDX?

2 Answers   TCS,


Explain what are components of report studio?

1 Answers  


Which columns go to the fact table and which columns go the dimension table?

1 Answers  


Can you state some of the innovations throughout history?

1 Answers  


What are vaious etl tools in the market?

1 Answers  


Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends

1 Answers  


What are the types of partitioning?

1 Answers  


After the complete generation of a report who will test the report and who will analyze it?

1 Answers  


What is DTM session?

1 Answers  


Categories