ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Ab Initio
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
In Join component which record will go to unused port and 
which will go to reject port ?
 Question Submitted By :: Ambuja Panda
I also faced this Question!!     Rank Answer Posted By  
 
  Re: In Join component which record will go to unused port and which will go to reject port ?
Answer
# 1		 
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 ?    5 Yes 0 No
KumarG
 
  Re: In Join component which record will go to unused port and which will go to reject port ?
Answer
# 2		 
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 ?    5 Yes 0 No
Akj
 
 
 

 
 
 
Other Ab Initio Interview Questions
 
  Question Asked @ Answers
 
what is the relation between EME , GDE and Co-operating system ?  4
What is air_project_parameters and air_sandbox_overrides? what is the relation between them?  1
what is deeup in unique only? IBM3
How to get DML using Utilities in UNIX?  1
What is meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?  2
What is AB_LOCAL expression where do you use it in ab- initio? Cognizent4
What is the latest version that is available in Ab-initio?  3
What are Cartesian joins?  2
If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.  2
What is meant by Co > Operating system and why it is special for Ab-initio ?  1
Graph was failed how it is achived ? send answer with phone number? i want speak with directly who is intrest on abinitio? HCL1
How many parallelisms are in Abinitio?  2
what is the syntax of m_dump command?  2
What is the difference between In-Memory Sort and Inputs must be sorted?  2
One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..  1
what is skew and skew measurement?  1
i need help from u. i want to learn abinitio. please provide pdfs or material or books.  10
How to run the graph without GDE?  1
I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how is in Type 1 and how is it on type 2? IBM1
What is the difference between a DB config and a CFG file? Wipro4
 
For more Ab Initio Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com