Interested to Buy Any Domain ? << Click Here >> for more details...
How to load data into 3 target tables which are in
different schema but with the same name and same relational
connection at infromatica level ?
How to differentiate while loading ? and how to load ?
- 2 Answers
- 9901 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / robin
use scheman name as prefix in the table name in session
properties.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain the etl program with few examples.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
scenario where i can use only concurrent execution of workflow.
what are factless facts? And in which scenario will you use such kinds of fact tables.
can we override a native sql query within informatica? Where do we do it?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is status code in informatica?
How many number of sessions can one group in batches?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the settings that you use to configure the joiner transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
How an expression transformation differs from aggregator transformation?
What is standalone command task?
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?
What are batches?
