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...

  1. Categories >> Software >> Data Warehouse >> Ab Initio
  2. Suggest New Category

In Join component which record will go to unused port and
which will go to reject port ?

Question Posted / ambuja panda

Answers were Sorted based on User's Feedback



In Join component which record will go to unused port and which will go to reject port ?..

Answer / kumarg

In case of inner-join all the records not matching the key
specified goes to the respective unused ports, in full
outer-join none of the records goes to the unused ports. In
case of reject port, records which do not match with DML
come to the reject port.

Is This Answer Correct ?    23 Yes 2 No

In Join component which record will go to unused port and which will go to reject port ?..

Answer / akj

In case of inner-join all the records not matching the key
specified goes to the respective unused ports, in full
outer-join none of the records goes to the unused ports.
All the records which evaluates to NULL during joiin
transformation will go into reject port if the limit +
ramp*number_of_input_records_so_far <
number_of_input_records_so_far.

Is This Answer Correct ?    15 Yes 2 No

In Join component which record will go to unused port and which will go to reject port ?..

Answer / gopichinnu

Hi,

In join component suppose if we r using join type as
innerjoin,which records r going to meet the particula type
that records will go to the outport and remaining records
will go to the unused port.

suppose our data contains null values will go to reject
port.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Ab Initio Interview Questions

why Skew should always be 0 ? How to use in abinitio graph?

1 Answers   IBM, TCL,

What is brodcasting and replicate?

0 Answers  

What are the benefits of data analyzing?

0 Answers  

what is skew and skew measurement?

2 Answers   TCS,

If you check in one file twice in EME, one with a tag and second without a tag - Will the version number change ? How to use in abinitio graph?

2 Answers   IBM, TCL,

i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.

4 Answers   L&T,

How can we increase the loading performance of oracle table in AbInitio?

0 Answers  

What is the default layout of a component ? Is it mandatory to set the layout of a component ?

3 Answers   IBM,

How do you add default rules in the transformer?

0 Answers  

How to connect mainframe to Abinitio?

1 Answers   CTS,

What is the significance of record required indicator of Join component ? How to use in abinitio graph?

2 Answers   IBM, TCL,

What are the primary keys and foreign keys?

0 Answers  

For more Ab Initio Interview Questions Click Here
Categories