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 |
what is the use of Java Transformation in Informatica 8.x?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
What are the basic needs to join two sources in a source qualifier?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
What is the role of informatica in project ?Like i showed financial projects?
How to create the source and target database connections in server manager?
How can you join two tables without any common column present in them?
What is the difference between unicode & ascii mode data movement in informatica?
how do the project develops? pls specify right from the start to end in step by steps.
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
Explain the features of connected and unconnected lookup.
What is meant by a domain?