Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 2 Answers
- 9880 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / robin
use scheman name as prefix in the table name in session
properties.
| Is This Answer Correct ? | 5 Yes | 0 No |
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 |
Separate from an archive server and a powerhouse?
what r the values tht r passed between informatics server and stored procedure?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
how DTM buffer size and buffer block size are related
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
How do you create single lookup transformation using multiple tables?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
What is active and passive transformation?
why we use informatica in our project?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
Which files are created during the session rums by informatics server?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
Teradata 
