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   SiteMap shows list of All Categories in this site.
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
How will u remove header record? How will u remove tailer 
record?
 Question Submitted By :: Veluruabinitio
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How will u remove header record? How will u remove tailer record?
Answer
# 1
There can be many ways to remove header & trailer record 
depending on the data you are receiving. If you have a 
particular signature for header & Trailer record you can 
use Filter by Expression or Partition By Expression 
Component to remove the header & Trailer record. If you 
don't have signature for your header & Trailer record then 
you have to use reformat component to select only the data 
record.
 
Is This Answer Correct ?    5 Yes 2 No
Dhirendra
 
  Re: How will u remove header record? How will u remove tailer record?
Answer
# 2
if there is no clue about how the header and trailer would 
be then put a filter with next_in_seq = 1 to remove the 
header and dedup the whole input with all fields as key and 
keep last to remove the trailer.
 
Is This Answer Correct ?    0 Yes 0 No
Rit
 
 
 
  Re: How will u remove header record? How will u remove tailer record?
Answer
# 3
Yes can be done with the help of REFORMATE component in 
this use reformat out put index.if we use this we can get 
what ever out we need.

OR
With the help of Run progame compnent.
 
Is This Answer Correct ?    0 Yes 0 No
Nag
 

 
 
 
Other Ab Initio Interview Questions
 
  Question Asked @ Answers
 
How Does MAXCORE works?  3
How can we RUN a graph in UNIX?  3
Have you eveer encountered an error called "depth not equal"?  2
How do we handle if DML changing dynamicaly? IBM3
How to get DML using Utilities in UNIX?  1
Is there any function in ab Initio which act like SCAN component  1
What is meant by Co > Operating system and why it is special for Ab-initio ?  1
What is air_project_parameters and air_sandbox_overrides? what is the relation between them?  1
what is the syntax of m_dump command?  2
Output for sort and dedupsort with NULL key?  3
What is .abinitiorc and What it contain?  2
What is the difference between a DB config and a CFG file? Wipro4
What is the difference between partitioning with key and round robin?  4
Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...  1
what are kinds of layouts does ab initio supports ?  3
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 $mpjret? Where it is used in ab-initio?  2
What does dependency analysis mean in Ab Initio? Syntel2
Describe which system or process elements you would review when trouble-shooting general server slows ?  1
What is the difference between In-Memory Sort and Inputs must be sorted?  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 interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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