How will you combine 3 different sources with a single source?
- 3 Answers
- 7441 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Global and Local shortcuts. Advantages.
What are batches?
Describe an informatica powercenter?
complex mapping ur project u r invlve can u explain and give real time example give me ?
define galaxy repository in informatica
What are the different versions of informatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to do the error handling of if ur source is flatfiles?
As union transformation gives UNION ALL output, how you will get the UNION output?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is meant by incremental aggregation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Name the different lookup cache(s)?
