Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
Answers were Sorted based on User's Feedback
Answer / bidhar
First thing to note is that Both the sources must be
Homogeneous.
Also the Order of the ports in SQ and the order of the
Columns in the select query (if you are using SQL override)
must be same.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
where to select code page option?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
As union transformation gives UNION ALL output, how you will get the UNION output?
How to do Integration testing in Informatica?
What is the difference between Bulk Load and Normal Load
Can we call a stored procedure from a unix script which is run using command task
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
How many repositories can we create in Informatica??
what is data driven in update strategy transformation?
Difference between task flow and linear task flow
How can you increase the performance in joiner transformation?
Could any one to tell Fact table Partitioning?