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
- 9998 Views
- IBM, I also Faced
- E-Mail Answers
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
in reporting we add some new objects,how we get the count of the newly added objects to the report
How you can differentiate between connected lookup and unconnected lookup?
Whats there in global repository
Which version configuration tool used in ur project?
How to create the source and target database connections in server manager?
Can we override a native sql query within informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
In which transformation you cannot drag ports into it?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the features of complex mapping?
Define mapping and session?
How to update or delete the rows in a target, which do not have key fields?
How many dimensions are there in informatica?
