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


Please Help Members By Posting Answers For Below Questions

How to load last n records of file into target table - informatica

703


What do you mean by filter transformation?

644


What are the different ways to implement parallel processing in informatica?

974


Why do we need informatica?

643


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1540






How to improve the performance of a session using sorter transformation?

790


what is the hint? how to use it to reduce the query processing in program?

6674


What are the measure objects?

770


What is a router transformation?

727


update strategy transformation in informatica

745


Can we change Dynamic to Static or Persistent cache? If so what happens?

1811


Write the unconnected lookup syntax and how to return more than one column.

699


Describe data concatenation?

665


What is a code page?

800


What is the different lookup cache(s)?

712