Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
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
What is meant by query override?
Have you worked with/created Parameter file
What are the mapping parameters and mapping variables?
How do you handle two sessions in Informatica
How would you join a node to the already existing domain?
What is an expression transformation in informatica?
What the difference is between a database, a data warehouse and a data mart?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Differentiate between router and filter transformation?
What are the designer tools for creating transformations?
What are the advantages of using informatica as an etl tool over teradata?
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.
How many ways are there to create ports?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is mapplet in informatica?