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
- 8049 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 |
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Mention few power centre client applications with their basic purpose?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
what are the unix commands to start the wrk flow ?
how to identify new and old values in source qualifier or any other transformations using informatica
what is data driven?
Can we have a Mapping without a Source Qualifier?
What is a configuration management?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
What is an incremental loading? in which situations we will use incremental loading
What is a command that used to run a batch?
Teradata 
