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
- 20475 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
Name the different lookup cache(s)?
Define Pmrep command?
What is target load order?
What are the main issues while working with flat files as source and as targets ?
Describe expression transformation?
How can you validate all mappings in the repository simultaneously?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are pre and post-session shell commands?
How to extract sap data using informatica?
What is a sorter transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What you know about transaction control transformation?
What is a dimensional model?
can we override a native sql query within informatica? Where do we do it?
