what is sql override?what is the use of it?

Answer Posted / soujanya

It is a process of writing user defined SQL queries to
define SQL joins,source filters, sorting input data and
eliminating duplicates

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1275


Performance tuning( what you did in performance tuning)

1702


What is the need of an ETL tool?

832


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6376


Can we create a Integration service without a Repository service and vice versa?

972


Is it possible to use a client with different version than that of its Informatica server?

851


Tell me about Propagate functions in informatica

703


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1771


What is union transformation?

736


Whats there in global repository

1440


difference between repository database and repository service?

826


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1898


What is the format of informatica objects in a repository?

801


What do you mean by blocking transformation?

774


What is the commit type if you have a transaction control transformation in the mapping?

827