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 |
What is etl process?
what is a worklet?
what is pmrep command?
Explain me ETL project architecture in Detail?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What do you understand by the term ‘transformation’?
What is Data Vault???
What are snapshots?
What is fact? What are the types of facts?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is data cleaning?