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
- 8034 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 |
How to join three sources using joiner? Explain though mapping flow.
why union transformation is active transformation?
What are Business Components in Informatica?
Explain what transformation and how many are there in informatica?
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
How identifying bottlenecks in various components of informatica and resolving them?
How can repository reports be accessed without sql or other transformations?
Where do you create/define mapping parameter and mapping variable?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
scenario where i can use only concurrent execution of workflow.
Teradata 
