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
I have a flat file, want to reverse the contents of the flat file
How to do unit testing in informatica?
How to update a particular record in target with out running whole workflow?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How big was your fact table
Differentiate between reusable transformation and mapplet.
How do you migrate data from one environment to another?
How does the aggregator transformation handle null values?
What is a standalone command task?
what are 3 tech challenges/ common issues you face?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the types of presistent cache in look up tr.
What is the difference between STOP and ABORT options in Workflow Monitor?
Differentiate between a database and data warehouse?
Explain the use of aggregator cache file?