After draging the ports of three sources(sql
server,oracle,informix) to a single source qualifier, can
you map these three ports directly to target?
Answer Posted / madhukar
We cant perform heterogeneous sources with sqt.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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.
if we have a delimiters at unwanted places in a flat file how can we over come those.
How do you migrate data from one environment to another?
What is aggregate cache in aggregator transformation?
Is there any way to read the ms excel datas directly into informatica?
Which is the t/r that builts only single cache memory?
Explain lookup transformation source types in informatica
What are the settings that you use to configure the joiner transformation?
How can a transformation be made reusable?
What is a connected transformation?
What is a snowflake schema?
What are Dimensional table?
Describe an informatica powercenter?
Explain the scenario which compels informatica server to reject files?
To import the flat file definition into the designer where should the flat file be placed?