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
Hi friends if u don't mind  i want one question What abt 
READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
 Question Submitted By :: Veluruabinitio
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
Answer
# 1
Reads an input record from the in port. 
Passes the input record to the get_filename transform 
function. 
If the get_filename function returns a string that does not 
contain a valid filename, or if the file derived from the 
string is empty or missing, Read Multiple Files proceeds 
according to what is specified in the filename-error, file-
empty, and file-missing parameters. 
If the get_filename function returns a string containing a 
valid filename, Read Multiple Files retrieves the specified 
file. 
 NOTE: The input file specified in the string must be local 
to the machine where Read Multiple Files is running. Note 
also that in multifile layouts, different instances of Read 
Multiple Files can be running on different computers, so 
input filenames referring to directories that exist only on 
particular computers must be partitioned carefully. To use 
relative paths, use the DML function this_partition_path. 

Opens the specified file and reads records from it: 
If an input_type data type is defined in the transform 
package, Read Multiple Files uses this type to read records 
from the file. If you omit input_type, Read Multiple Files 
uses the record type defined on the out port. 
If the filter parameter was set to Range, and the skip-
count parameter is non-0, Read Multiple Files skips the 
specified number of records before reading subsequent 
records from the file. 
If the filter parameter was set to Range, and the read-
count parameter is non-0, Read Multiple Files reads up to 
this maximum number of records from the file. If read_count 
is less than or equal to zero, Read Multiple Files reads 
the remainder of the file. 
Read Multiple Files writes records to the out port. 
If a reformat function is defined in the transform package, 
the component passes each record read from the input file 
to the reformat function, along with the filename. The 
output of the reformat function is written to the out port. 
If you omit a reformat function, but provide an input_type 
data type in the package, the component behaves like a 
Reformat component with no transform package, reading 
records from the file using the input_type, and performing 
any conversion necessary to match the record format on the 
out port. 
If the reject and error ports are connected to flows and 
the reformat transform function returns NULL, Read Multiple 
Files writes an error message to the error port and the 
current record to the reject port. 
Read Multiple Files stops execution of the graph when the 
number of reject events exceeds the value given by the 
following formula:

limit + (ramp * number_of_records_processed_so_far) 

For details, see "Setting limit and ramp for reject events"

If you do not connect flows to either the reject or error 
port, Read Multiple Files does not write an error message 
and discards the rejected record.
 
Is This Answer Correct ?    0 Yes 0 No
Dhirendra
 

 
 
 
Other Ab Initio Interview Questions
 
  Question Asked @ Answers
 
Describe how you would monitor and control database physical file size and growth? Satyam3
What is .abinitiorc and What it contain?  2
What is $mpjret? Where it is used in ab-initio?  2
Do we really work with ACTUALDATA in development phase.  2
Graph was failed how it is achived ? send answer with phone number? i want speak with directly who is intrest on abinitio? HCL1
What is the difference between partitioning with key and round robin?  4
name the air commands in ab initio? Syntel1
what is skew and skew measurement?  1
What is a ramp limit?  2
Is there any function in ab Initio which act like SCAN component  1
what is deeup in unique only? IBM3
What is the latest version that is available in Ab-initio?  3
How do we handle if DML changing dynamicaly? IBM3
Output for sort and dedupsort with NULL key?  3
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
How Does MAXCORE works?  3
What is AB_LOCAL expression where do you use it in ab- initio? Cognizent4
What is air_project_parameters and air_sandbox_overrides? what is the relation between them?  1
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 the difference between .dbc and .cfg file?  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