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
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to extract sap data using informatica?
Briefly explain the aggregator transformation?
What is status code in informatica?
What is dynamic cache?
What is the Process to creating lookup transformation in informatica
What is the difference between router and filter?
What is the use of target designer?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are Dimensional table?
Which transformation should we use to normalise the COBOL and relational sources?
Differentiate between joiner and lookup transformation?
What is the session task and command task?