Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
Answer Posted / 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 |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is update strategy transform?
What the difference is between a database, a data warehouse and a data mart?
what is the complex transformation you used in informatica
What is rank index in rank transformation?
Repository user profiles
What is the use of code page?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
can we override a native sql query within informatica? Where do we do it?
Explain the informatica workflow?
How are the sources and targets definitions imported in informatica designer?
What is a filter transformation?
What are the settings that you use to configure the joiner transformation?