What is sql query override? When did u use sql query override?
Answer Posted / santhosh
sql override is used to write sql select statements
sql override contains in source qualifier transformation
we can use sql override when the source and target are
homogenious database
it will not support flatfiles and hedrogenious database
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Plz can any one say me how to get the informatica certification materials and dumps
What are the settings that you use to configure the joiner transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How you prepared reports for OLAP?
Define enterprise data warehousing?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain transaction control transformation in informatica
How to generate sequence numbers using expression transformation?
What is rank transformation in informatica
What is incremental aggregation?
What are the different lookup cache(s)?
What is status code in informatica?
Is there any way to read the ms excel datas directly into informatica?
Do you find any difficulty while working with flat files as source and target?
where to store informatica rejected data? How to extract the informatica rejected data?