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 / pentaho
v can use user define join ........
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by SOA of Informatica?
What is dimensional table?
What is meant by target load plan?
Can we create a Integration service without a Repository service and vice versa?
Can you generate sequence numbers without using the sequence generator transformation?
What is union transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are connected or unconnected transformations?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
differences between service based and product based?
Parameter and variable differences
How we can create indexes after completing the loan process?
What is the scenario which compels informatica server to reject files?
What is target designer and target load order?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks