Interested to Buy Any Domain ? << Click Here >> for more details...
How will you combine 3 different sources with a single source?
- 3 Answers
- 8645 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pooja
hi,
please get clear picture on the Question...
1. wherther all 3 source are in same schma or in differt
schme ..
if its in differnt schma means use joiner
if its same schma means u cn override the SQ query
2. if no.of columne and datatype are same for all the 3
source means you can use union trans....
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / madhu
we can use sourcequalifier transformation
or union transformation to combine different source to a
single source
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rkumar.etl
use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.
| Is This Answer Correct ? | 1 Yes | 0 No |
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
without using emailtask how will send a mail from informatica?
comonly how meny mappings r there in Banking projects?
What is informatica? What exactly are the practical uses in real world
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
In which circumstances that informatica server creates Reject files?
what is the difference between copy object import objects using repositery manager which one is best
what is the predefined port in dynamic lookup
How to update source definition?
Which transformation is needed while using the Cobol sources as source definitions?
Explain why we use partitioning the session in informatica?
Teradata 
