Interested to Buy Any Domain ? << Click Here >> for more details...
Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
- 2 Answers
- 8051 Views
- I also Faced
- E-Mail Answers
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 look up transformation?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
what is sql override?what is the use of it?
How do you implement scheduling in Informatica?
how DTM buffer size and buffer block size are related
How to elaborate tracing level?
what is meant by data driven.. in which scenario we use that..?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the rank caches?
What are the different components of powercenter?
Teradata 
