Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
- 2 Answers
- 6992 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How identifying bottlenecks in various components of informatica and resolving them?
What is the Process to creating lookup transformation in informatica
What all join we can perform in LOOKUP transformation?
What is data transformation manager process?
How to handle decimal places while importing a flatfile into informatica?
What is blocking transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the types of schemas we have in data warehouse and what are the difference between them?
What is a difference between complete, stop and abort?
How to create the source and target database connections in server manager?
What is an unconnected transformation?
What are the popular informatica products?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain direct and indirect flat file loading (source file type) - informatica
Can u generate reports in Informatica?
