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
- 22224 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
How can you differentiate between powercenter and power map?
In how many ways we can create ports?
Briefly describe lookup transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Write the prerequisite tasks to achieve the session partition?
How to convert multiple rows to single row (multiple columns) in informatica
What are the different components of powercenter?
Explain sessions. Explain how batches are used to combine executions?
What are the reusable transformations?
In which transformation you cannot drag ports into it?
What is data movement mode in Informatica and difference between them?
What is the fact table?
What does command task mean?
Explain what are the different types of transformation available in informatica.
Separate from a database, an information bazaar, and an information stockroom?
