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 |
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What are various etl tools in the market?
dimension object created in oracle can be imported in designer?how?
if i have a query as flat file how can we load data to target table
what are the reporting tools and difference between them?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
Compare etl & elt?
In Which Transformation We Can Use Having Clause In Informatica?
What are cubes and olap cubes?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What is tracing level?
What are the differences between sql override and update override?