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
- 10127 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 |
What is the session task and command task?
What are limitations of joiner transformation?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
How can we get two output ports in un-connect transformation?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
What are the different options available for update strategy?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
How informatica process data means how informatica works?
What are the components of Informatica? And what is the purpose of each?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
Teradata 
