Interested to Buy Any Domain ? << Click Here >> for more details...
Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
- 2 Answers
- 8157 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishna
1.two or more relational tables are with primary key-
foreign key relationships by linking the sources to one
Source Qualifier transformation.
2.the data types of the ports must match.
violation of these two conditions may lead to errors while
joining two tables
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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?
What are Dimensional table?
What is decode in informatica?
Explain dynamic target flat file name generation in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain lookup transformation is active in informatica
What is Session and Batches?
What is resilience time?
How to call shell scripts from informatica?
How might you approve all mappings in the archive all the while?
Different qualification between a related rotate toward the sky and isolates look upward?
What is aggregator transformation in informatica?
what is index?how it can work in informatica
What's the layout of parameter file (what does a parameter file contain?)?
How to differentiate between the active and passive transformations?
