Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?

Answers were Sorted based on User's Feedback



Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown? ..

Answer / 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

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown? ..

Answer / 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

More Informatica Interview Questions

where to select code page option?

2 Answers   TCS,


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.

0 Answers  


As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,


How to do Integration testing in Informatica?

5 Answers   Intelligroup,


What is the difference between Bulk Load and Normal Load

3 Answers   TCS,


Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,


how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  


How many repositories can we create in Informatica??

9 Answers   IBM, Patni,


what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,


Difference between task flow and linear task flow

0 Answers  


How can you increase the performance in joiner transformation?

0 Answers  


Could any one to tell Fact table Partitioning?

2 Answers  


Categories