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 ?
Answer Posted / kritika
in the session we can give different connections based upon the database we want to load. In each table there will be different connection where we can give different database name
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How can you define user defied event?
What is a stored procedure transformation?
What are the different components of powercenter?
Describe data concatenation?
Differentiate between a repository server and a powerhouse?
How can one identify whether mapping is correct or not without connecting session?
On which transformations you created partitions in your project?
Scheduling properties,whats the default (sequential)
How does the aggregator transformation handle null values?
How to load data in informatica ?
How can we use mapping variables in informatica?
What are the reusable transformations?
What is a joiner transformation and why it is an active one?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to create or import flat file definition in to the warehouse designer?