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 all are steps in up gradation of Informatica server?
In dimension and fact table? which one holds big data?
What is the Hierarchy of DWH?
what is materialized view?
What is the difference between a table and the materialized view?
what is fact table?
star and snowflake schema?
What is the advantage of persistent cache? When it should be used.
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
HOW DO YOU CONNECT TO REMOTE SERVER ?
h0w many versions have been developed of onformatica so far?
What is meant by lookup transformation? Explain the types of lookup transformation?