Interested to Buy Any Domain ? << Click Here >> for more details...
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
- 5 Answers
- 9592 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kumarapillaietl@gmail.com
We can write any order under SQL query like Oracle SQL part , but the main thing is we need to maintain that query order in our all mapping flow. Else it's error
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How would you copy the content of one repository to another repository?
tell me about your project functionality
In warehouses how many schemas are there?
What is meant by lookup transformation?
What does update strategy mean, and what are the different option of it?
What are the differences between joiner transformation and source qualifier transformation?
tell me 5 session failure in real time how can you solve that in your project?
What is dynamic cache?
Describe data concatenation?
Describe the impact of several join conditions and join order in a joiner transformation?
What is informatica etl tool?
What differs when we choose the sorted input for aggregator transformation?
What is enterprise data warehousing?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the way to execute pl/sql script using informatica mapping?
