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   interview questions urls   External Links  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
Output for sort and dedupsort with NULL key?
 Question Submitted By :: Ram1234
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Output for sort and dedupsort with NULL key?
Answer
# 1
Whenever we sort a set of records with NULL key 
automatically it consider the records as one group & data 
will be as per the input serial number and will be sorted 
according to that.But dedup will again cosider the records 
as one group &  output will be the first record 
automatically.
e.g.input records:1,XYZ,100;
                  2,ABC,700;
                  5,JJJ,400;
                  7,KKK,500;
 using NULL key sort component will give output as:
                  1,XYZ,100;
                  2,ABC,700;
                  5,JJJ,400;
                  7,KKK,500;
Dedup sort will give output as:
                  1,XYZ,100;
 
Is This Answer Correct ?    2 Yes 2 No
Koel
 
  Re: Output for sort and dedupsort with NULL key?
Answer
# 2
i think in the above case dedup sort will give all the
records in out put even if we sort on any of the three 
fields
 
Is This Answer Correct ?    1 Yes 2 No
Raj
 
 
 

 
 
 
Other Ab Initio Interview Questions
 
  Question Asked @ Answers
 
wt is meant by repartioning in howmany ways it can be done.  1
How to Create Surrogate Key using Ab Initio?  3
How do we extract data from client machine?  1
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.  1
What is .abinitiorc and What it contain?  2
How to Improve Performance of graphs in Ab initio?  1
Have you eveer encountered an error called "depth not equal"?  2
what are kinds of layouts does ab initio supports ?  2
what is the syntax of m_dump command?  1
what is skew and skew measurement?  1
What is the difference between a DB config and a CFG file? Wipro4
How might you quantitatively measure an improvement made to a query?  1
i need help from u. i want to learn abinitio. please provide pdfs or material or books.  3
Output for sort and dedupsort with NULL key?  2
Describe how you would monitor and control database physical file size and growth? Satyam3
How to get DML using Utilities in UNIX?  1
What is a ramp limit?  2
what is meant by fancing in abinitio ?  1
What are the different versions and releases of ABinitio ?  1
what does layout means in terms of Ab Initio?  2
 
For more Ab Initio Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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