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
- 24258 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / dada
Hi Guys,
We can use union transformation to join 100 tables.but the
thing is it should be same structure.by using one union we
can do it. for ex all 100 tables have same order,datatype
(std_name,loc,dept) then only we can do it by union.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
EXL informatica Questions
How do you load alternate records into different tables through mapping flow?
Explain joiner transformation in informatica
How can a transformation be made reusable?
How to handle decimal places while importing a flatfile into informatica?
What are the components of Informatica? And what is the purpose of each?
What is the benefit of session partitioning?
What is joiner change?
How do we call shell scripts from informatica?
Can anyone tell me the new features in Informatica 9 Version?
Explain the difference between a data warehouse and a data mart?
Name the different lookup cache(s)?
What is the sequence generator transformation in informatica?
What do you mean by worklet?
How are indexes created after completing the load process?
