Explain the key challenges that you face while performing etl testing.
- 1 Answers
- 1080 Views
- I also Faced
- E-Mail Answers
Answer / Mani Saxena
{"ETL Testing Challenges": [n {"Challenge Name": "Data Volume","Description": "Handling large volumes of data can lead to performance issues and increased time for testing.n },n {"Challenge Name": "Data Quality","Description": "Ensuring the quality of data during the ETL process is crucial, as any errors or inconsistencies can have significant impacts on the downstream processes and analytics.n },n {"Challenge Name": "Transformation Complexity","Description": "Transformations can be complex, making it difficult to test all possible scenarios and edge cases.n },n {"Challenge Name": "Data Timeliness","Description": "Ensuring that data is processed and loaded into the data warehouse in a timely manner is important for maintaining the accuracy of analytics and decision-making processes.n }n]}
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the data modeling tools you have used?(polaris)
In Which Transformation We Can Use Having Clause In Informatica?
1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com
Identifying the bottlenecks in various components of Informatica and resolving them.
can be used COM component in Informatica ?
how many steps are there in etl process?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
1 Answers IBM, Saama Tech, Wipro,
List few etl bugs?
what is the difference between cardinality and Nullability?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
Is apache nifi an etl tool?
What do you understand by the term ‘transformation’?
Teradata 
