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 |
scenario where i can use only concurrent execution of workflow.
can we generate reports in informatica ? How?
What is a joiner transformation and why it is an active one?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
what is the monster dimension plz give me one example
Diffrence between static and dynamic cache
wht is full process of Information source to target just like stg to productuon and development
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
What is confirmed dimension?
what is hash table in informatica?
What is a filter transformation and why it is an active one?
Which transformation should we use to normalise the COBOL and relational sources?