How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example)
Answer Posted / sarvesh
by using the sql override option in the edit properties in
s.q transformation,
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
what is session partitioning?
What are various etl tools in the market?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is the difference between round-robin partitioning and hash partitioning?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
when will use SQL override in a lookup transformation?
what are the reporting tools and difference between them?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
Explain the use lookup tables and Aggregate tables?
When do we go for the tools in the market?
What are the various tools used in etl?
Explain about the data integration suite features?