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

Can we create a Integration service without a Repository service and vice versa?

733


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

706


What is the meaning of up gradation of repository?

1402


explain abt ur project architecture?

1769


How many transformations can be used in mapplets.

1468






what is INFORMATICA TESTING process

1851


How to update a particular record in target with out running whole workflow?

1167


What are the basic requirements to join two sources in a source qualifier transformation using default join?

625


Explain the code page compatibility?

649


What is meant by lookup transformation?

621


What is a predefined event?

672


What is meant by incremental aggregation?

593


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4998


Explain dynamic target flat file name generation in informatica

656


Describe an informatica powercenter?

621