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 / 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


Please Help Members By Posting Answers For Below Questions

Make a note of the quantity vaults made in informatica?

547


What do you mean by worklet?

622


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1889


While importing the relational source definition from the database, what are the metadata of source that will be imported?

781


my source is junk data how will u remove that junk data by using unix please any one replay me

3235






What is rank transformation in informatica

685


In how many ways we can create ports?

697


What is workflow manager?

569


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4766


What is sq transformation?

654


What is the use of target designer?

600


what is SDLC way of code development?

1553


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1312


What are the different lookup cache(s)?

614


What are active and passive transformations?

645