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


Please Help Members By Posting Answers For Below Questions

I have a flat file, want to reverse the contents of the flat file

686


How to do unit testing in informatica?

718


How to update a particular record in target with out running whole workflow?

1153


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

603


How big was your fact table

1310






Differentiate between reusable transformation and mapplet.

568


How do you migrate data from one environment to another?

641


How does the aggregator transformation handle null values?

695


What is a standalone command task?

652


what are 3 tech challenges/ common issues you face?

1882


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

628


What are the types of presistent cache in look up tr.

1543


What is the difference between STOP and ABORT options in Workflow Monitor?

691


Differentiate between a database and data warehouse?

650


Explain the use of aggregator cache file?

671