How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example)
Answer / sarvesh
by using the sql override option in the edit properties in
s.q transformation,
| Is This Answer Correct ? | 2 Yes | 2 No |
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
what are the different Reporting and ETL tools available in the market?
Identifying the bottlenecks in various components of Informatica and resolving them.
Can u access a repository created in previous version of Informatica?
what is the difference between OLTP database and data warehousing database?
how would u estimate the size of Aggregator transform data and index cache?
Explain about enterprise scalability and roi of data integration suite?
how do u automate Extraction process?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
What are the differences between sql override and update override?
What are the ETL Testing Operations?