Interested to Buy Any Domain ? << Click Here >> for more details...
How will you combine 3 different sources with a single source?
- 3 Answers
- 8483 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 |
waht is dataware house
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
What are the reusable transformations?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
How to handle changing source file counts in a mapping?
What is an Integration service in Informatica?
Explain the etl program with few examples.
How many ways a relational source definition can be updated and what are they?
Teradata 
