Interested to Buy Any Domain ? << Click Here >> for more details...
How will you combine 3 different sources with a single source?
- 3 Answers
- 8478 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 |
What are the different options available for update strategy?
What is the query to find nth highest salary? What is the use of cursors?
what is threshold error in informatica?
Is there any model difference between ODS and DWH
What are the advantages of using informatica as an etl tool over teradata?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
What are the differences between source qualifier and joiner transformation?
what is the difference between mapplet & stored procedure?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Is there any target staging area in informatica not staging area
Teradata 
