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

How do we handle if DML changing dynamicaly?

5 Answers   GE, HP, IBM, Mannar Company,

Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999

1 Answers  

What dedup-component and replicate component does?

0 Answers  

. How can you get all the fields form a lookup files ? (Which function)

3 Answers   TCL,

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

2 Answers   IBM, TCL,

How to add default rules in transformer?

0 Answers  

How to create repository in abinitio for stand alone system(local nt)?

0 Answers  

How to calculate total memory used my a graph?

1 Answers   IBM,

what does layout means in terms of Ab Initio?

3 Answers  

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

0 Answers  

How you can generate surrogate key? How to use in abinitio graph?

2 Answers   IBM, TCL, Torry Harris,

. How we can remove temp files of a failed job if .rec is not available

2 Answers  

For more Ab Initio Interview Questions Click Here
Categories