To unfold a bit on the other answers how to create table in pl SQL procedure. Yes, you must use dynamic SQL to produce a table or perform any other kind of DDL (data description language) operation in PL/ SQL. There are two commonly used methods to execute DDL from PL/ SQLFirst, “ roll your … Read more
Google: How Do You Optimize a Power BI Data Model and DAX Queries to Perform Efficiently on Datasets Exceeding 200 Million Rows? Google is known for working with some of the largest datasets on the planet. Even internal BI and analytics teams handle billions of transactions, logs, events, impressions, and user interactions across Search, YouTube, … Read more
Amazon: How Do You Design a High-Performance Power BI Dashboard Using DirectQuery Without Causing High Query Latency? Amazon is known for building hyper-scalable, high-performance analytics solutions across departments such as Retail, AWS, Finance, Prime Video, Logistics, Supply Chain, Payments, and Marketplace Seller Analytics. Most Amazon BI teams use Power BI + DirectQuery on top of … Read more
Wipro: How Do You Convert a Fully Normalized ERP Dataset Into a Performance-Optimized Star Schema for Enterprise Reporting in Power BI? Wipro works with large global enterprises running complex ERP systems like SAP ECC, SAP S/4HANA, Oracle EBS, Microsoft Dynamics, Infor, and legacy mainframe-based systems. These ERP systems typically store their data in a highly … Read more
Cognizant: How Do You Build an Efficient ETL Workflow Using Azure Data Factory for High-Frequency Data Loads? Cognizant (CTS) is one of the world’s leading technology consulting companies, handling large-scale data engineering projects for enterprise clients in banking, healthcare, insurance, telecom, energy, and retail domains. Most Cognizant projects involve high-frequency, high-volume ETL pipelines where data … Read more
EY: How Do You Reduce Memory Footprint in Power BI When Importing Fact Tables Above 80 Million Rows? This is one of the most frequently asked questions in EY (Ernst & Young) Power BI, BI Architect, Data Engineering, and Analytics interviews. EY handles large-scale enterprise analytics implementations across banking, taxation, audit, insurance, global finance, supply … Read more
Capgemini: How Do You Implement Multi-Layer Row-Level Security (RLS) Across Regions, Departments & User Roles in Power BI? This is one of the most frequently asked questions in Capgemini Power BI, Data Analyst, BI Developer, and Data Engineering interviews. Capgemini works with complex global clients who need dashboards where each user should only see the … Read more
Infosys: How Do You Troubleshoot Incorrect Results in Power BI When Relationship Directions Are Misconfigured? This is one of the most commonly asked questions in Infosys Power BI, Data Analyst, and BI Developer interviews. Infosys manages large enterprise BI implementations where Power BI models contain dozens of tables, complex relationships, multiple fact tables, role-playing dimensions, … Read more
Deloitte: How Do You Design a Scalable SQL Schema for Financial Reporting With Daily, Monthly & Quarterly Aggregations? This question is frequently asked in Deloitte SQL Developer, Data Engineer, and BI Architect interviews. Deloitte’s financial analytics projects deal with extremely large datasets, multiple reporting cycles, regulatory requirements, and complex aggregations across daily, monthly, quarterly, and … Read more