Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql override?what is the use of it?
- 4 Answers
- 16420 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / sunil
When u want to override the default sql query we will use
sql override
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
How can we use batches?
State the differences between sql override and lookup override?
What is aggregate cache in aggregator transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to do the error handling of if ur source is flatfiles?
How to create or import flat file definition in to the warehouse designer?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Where can we find the throughput option in informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is a rank transform?
What is different between the data warehouse and data mart?
Explain in detail about scd type 1 through mapping.
How is union transformation utilized?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How does the aggregator transformation handle null values?
