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
- 21313 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / bidhar
If the structure of 100 tables and the target table are
same then what is the use of joiner??
Here you need to do a Union.
If the structure of 100 tables and the target table are not
same then joiner should be used.
That means you will be picking up the desired Attributes
(columns) from these 100 tables and populating into the
target.
Please let me know your question clearly.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the different components of powercenter?
How does the aggregator transformation handle null values?
Why do you use Mapping Parameter and mapping variable?
How do you set a varible in incremental aggregation
What do you mean by enterprise data warehousing?
What are mapplets?
Why update strategy and union transformations are active? Explain with examples.
What are the popular informatica products?
During the running session, output files are created by informatica server. Enlist few of them.
What is the advantage of informatica?
What is a stored procedure transformation?
Explain what are the different versions of informatica?
What are the guidelines to be followed while using union transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What the difference is between a database, a data warehouse and a data mart?
