Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 12881 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kanth
Here they are having Heterogeneous sources how can those
can be joined at source quaifier.i think the question is
not clear u cannot darg the three heterogeneous siurces to
sinle source qualifier
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / atiric software(raja)
we cannot join haterogeneous sources in the s.q so we
cannot map those ports to target directly if we want we must
use the joiner transformation
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / bidhar
You cannot join Hetrogeneous sources in a SQ.For that you
need use joiner.For example if you have n hetrogeneous
sources then you must use n-1 joiners.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / madhukar
We cant perform heterogeneous sources with sqt.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / swetha
NO.Unless and until u join those three ports in source
qualifier you cannot map them directly.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / eric yang
To Swetha,
I am afraid these 3 ports have been joined already in source
qualifier, and therefore can map directly to a target, why not?
| Is This Answer Correct ? | 1 Yes | 2 No |
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
What are the types of maping in Getting Started Wizard?
Can you start a session inside a batch individually?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
what is the flow?
What is CHECK-IN CHECK-OUT. Please explane me?
what is unique constraint error ?
performance tuning of Informatica
what is flat file override?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
Teradata 
