what is sql override?what is the use of it?
Answer Posted / venkateshmalneni
we can write the sql queries in sql override.by using this sql override we can reduce the no of t/r in a mapping.
if no please let me know the correct answer
Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Define joiner transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to create the source and target database connections in server manager?
What is the advantage of informatica?
What is the fact table?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Define pmcmd command?
Performance tuning in UNIX for informatica mappings?
What is different between the data warehouse and data mart?
How can we create index after completion of load process?
How many types of sessions are there in informatica.please explain them?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What does role playing dimension mean?
How might you approve all mappings in the archive all the while?