Interested to Buy Any Domain ? << Click Here >> for more details...
i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task
- 14 Answers
- 24246 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / sanjay
well if u hav all related sources then u can probably go
for joiner but make sure that use less no. of joiner as it
may decrease your performance.
if u hav sources with same structure and data types then u
can probably go for set operation and matchin it with your
target.
the third one is u hav to do a lot of transformation based
on some analysis and might be u can create differnet
aliases for your target and you can apply your
transformation.
plz let me know if any clarification . your comment will be
appreciatable. :)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the components of workflow manager?
Differentiate between a repository server and a powerhouse?
Difference between Data and Index Caches?
What is a transaction control transformation?
What are roles and groups and benefits of using them?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the fact table?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the use of target designer?
What are the popular informatica products?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Why is sorter an active transformation?
What is rank transformation?
