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


Please Help Members By Posting Answers For Below Questions

Define joiner transformation?

589


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6399


How to create the source and target database connections in server manager?

622


What is the advantage of informatica?

643


What is the fact table?

584






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.

2293


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

603


Define pmcmd command?

618


Performance tuning in UNIX for informatica mappings?

2135


What is different between the data warehouse and data mart?

628


How can we create index after completion of load process?

592


How many types of sessions are there in informatica.please explain them?

674


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?

1314


What does role playing dimension mean?

621


How might you approve all mappings in the archive all the while?

600