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

What do you mean by channel change?

0 Answers  


how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,


What are the types of groups in Router transformation?

1 Answers   Informatica,


how can u tune u r informatica mapppings

2 Answers   CTS,


Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  


what is data driven?

5 Answers   TCS, Wipro,


Can you copy the session to a different folder or repository?

1 Answers  


What are different types of transformations available in informatica?

0 Answers  


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  


hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  


when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,


Categories