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 ?

Answers were Sorted based on User's Feedback



How to load data into 3 target tables which are in different schema but with the same name and sam..

Answer / robin

use scheman name as prefix in the table name in session
properties.

Is This Answer Correct ?    5 Yes 0 No

How to load data into 3 target tables which are in different schema but with the same name and sam..

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

More Informatica Interview Questions

How the dimensions will be loaded?

0 Answers   HCL,


What is workflow? What are the components of the workflow manager?

0 Answers  


how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  


What is a mapplet/worklet in informatica?

0 Answers  


hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  






What is status code in informatica?

0 Answers  


How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,


Mention some types of transformation?

0 Answers  


i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  


Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  


What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,


without using emailtask how will send a mail from informatica?

3 Answers  


Categories