Interested to Buy Any Domain ? << Click Here >> for more details...
How will you combine 3 different sources with a single source?
- 3 Answers
- 8650 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 |
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
Are there any types of Dynamic Caches in informatica
What is an aggregator transformation? it is active why cant it be passive explain?
How to configure mapping in informatica?
What are session parameters ? How do you set them?
Separate from an archive server and a powerhouse?
what is mean by grouping of condition column in lookup transformation?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
Define maping and sessions?
Explain how many types of dimensions are available in informatica?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
In how many ways we can create ports?
Teradata 
