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 is sql override?what is the use of it?

4 Answers   Sonata,


sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,


Difference between task flow and linear task flow

0 Answers  


can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,


Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,


Can you generate reports in Informatcia?

1 Answers  


What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,


can we override a native sql query within informatica? How do we do it?

0 Answers  


What is critical mapping?

2 Answers  


What is the difference between Power Centre and Power Mart?

5 Answers   TCS,


In dimension and fact table? which one holds big data?

2 Answers  


Categories