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
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 is the complex transformation you used in informatica
Is there any way to read the ms excel datas directly into informatica?
Which development components of informatica have the highest usage?
Explain the code page compatibility?
Describe expression transformation?
what is informatica metadata?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How do you convert single row from source into three rows into target?
What is the Process to creating lookup transformation in informatica
How to elaborate powercenter integration service?
What is informatica worklet?
What is informatica? Why do we need it?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you load first and last records into target table?