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 way to execute pl/sql script using informatica mapping?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
In informatics server which files are created during the session rums?
update strategy transformation in informatica
Describe data concatenation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is the hint? how to use it to reduce the query processing in program?
tell me 5 session failure in real time how can you solve that in your project?
how tokens will generate?
What do you mean by blocking transformation?
Difference between Data and Index Caches?
What are the restrictions of union transformation?
What are the data movement modes in informatica?
What is event and what are the tasks related to it?
Can you use flat files in Mapplets.