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 |
how to obtain performance data for individual transformations.
How can we improve session performance in aggregator transformation?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
what is the necessity to use update strategy?(except for updates)
what is parameter file?
How to load relational source into file target?
Can you copy the batches?
What is tracing level and what are the types of tracing level?
tell me 5 session failure in real time how can you solve that in your project?
My source table having some records ,i want load 1st record and last record into one target?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
What r the type of indexes u generally used in informatica?