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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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
What is meant header and tailer, suppose header and tailer 
had some junk data how will delete junk data ? which 
components r used?
 Question Submitted By :: Veluruabinitio
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?
Answer
# 1
In banking and financial modules every file will consists 
of Only one header records & Multiple Trailers (Transaction 
trailer & Batch trailer.

If it contains junk data we can do it by using Sed Editor 
or With help of PERAL SCRIPT.
 
Is This Answer Correct ?    0 Yes 0 No
Nag
 
  Re: What is meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?
Answer
# 2
1. If you know the signature of header and tailer record 
then use filerby expression component to filter the header 
and tailer records

2. Use one reformate component and then inside the 
transformation use next_in_sequence() function to assign 
unique numbers to each record,and then use filter by 
expression component to filter the records based on 
sequence numbers.

3.Follow the step 2 and use instead of filter by expression 
component use leading records component to filter the 
header and tailer records.
 
Is This Answer Correct ?    0 Yes 0 No
Mahendra Patnaik
 
 
 

 
 
 
Other Ab Initio Interview Questions
 
  Question Asked @ Answers
 
How can we RUN a graph in UNIX?  3
the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation? EDS2
Describe which system or process elements you would review when trouble-shooting general server slows ?  1
What is the latest version that is available in Ab-initio?  3
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
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 the difference between .dbc and .cfg file?  2
What is air_project_parameters and air_sandbox_overrides? what is the relation between them?  1
In Join component which record will go to unused port and which will go to reject port ? JPMorgan-Chase2
What is a ramp limit?  2
What is meant by Co > Operating system and why it is special for Ab-initio ?  1
what are the steps in actual ab initio graph processing including general,pre and post process settings?  1
What are Cartesian joins?  2
What is max core value ? what is the use of it? JPMorgan-Chase2
How to run the graph without GDE?  1
what is meant by fancing in abinitio ?  1
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?  1
What are the different versions and releases of ABinitio ?  1
name the air commands in ab initio? Syntel1
How to calculate total memory used my a graph? IBM1
 
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