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
 
 


 

Back to Questions Page
 
Question
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..
Rank Answer Posted By  
 Question Submitted By :: Muthu
I also faced this Question!!   © ALL Interview .com
Answer
Segregate the header, trailer & body by either using part 
by expression component or using filter by exp. Use 
next_in_sequence() function to a new column of the data 
record. Use sort on descending to sort the data on the 
next_in_sequence() column.
 
0
Dhirendra
 
 
Question
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...
Rank Answer Posted By  
 Question Submitted By :: Sheker2
I also faced this Question!!   © ALL Interview .com
Answer
RUN SQL COMPONENT

exec proc-name (parameters)
exec proc-name ('$DATE')
exec proc-name ('20080101')
 
0
Cse70938
 
 
Question
Output for sort and dedupsort with NULL key?
Rank Answer Posted By  
 Question Submitted By :: Ram1234
I also faced this Question!!   © ALL Interview .com
Answer
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;
 
0
Koel
 
 
 
Answer
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
 
0
Raj
 
 
Answer
Your result will come as per you specify the first/last
record. as it does not sort the records.

ex:
Input  
A   B   C
----------
1   a    d
4   f    h
6   y    g
7   g    u
2   i    o

Output
a: if selected first record in dedup
A   B   C
----------
1   a    d

b: if selected last record in dedup
A   B   C
----------
2   i    o

headers and trailers are processed like this only.
 
0
Mahendra Garewal
 
 
Question
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.
Rank Answer Posted By  
 Question Submitted By :: Ram1234
I also faced this Question!!   © ALL Interview .com
Answer
Yes the graph will run. Only the records in the partition 
being deleted won't be processed.
 
0
Jai
 
 
Question
wt is meant by repartioning in howmany ways it can be done.
Rank Answer Posted By  
 Question Submitted By :: Sekhar
I also faced this Question!!   © ALL Interview .com
Answer
Repartitioning Technique in Ab Initio is to apply 
departition on a data set and the apply Partitioning on the 
transformed data.
Its used when there is requirement of changing 2way mfs 
into 4way.
I dont know any otherways of achieving this Repartitioning.

Thanks
 
0
Lakshmi
 
 
Question
i need help from u. i want to learn abinitio. please provide
pdfs or material or books.
Rank Answer Posted By  
 Question Submitted By :: Narsingrao07
I also faced this Question!!   © ALL Interview .com
Answer
Hi 

I dont know how to attach pdf's in here, I can send it to 
your personal id if you send me your id, mine is 
d_deep12@yahoo.com
 
0
Deepak
 
 
Answer
please provide
pdfs or material or books on Abinitio
 
0
Chaithanya
[Cognizant]
 
 
Answer
I also need the materials .
 
0
Abhilash Dash
[Cognizant]
 
 
Question
How can we RUN a graph in UNIX?
Rank Answer Posted By  
 Question Submitted By :: Ram
I also faced this Question!!   © ALL Interview .com
Answer
Run the .ksh script generated by the GDE
 
0
Bharathi
 
 
Answer
a graph can be run by getting the script for the graph from 
the abinito interface and then running it using shell 
scripting
 
0
Guest
 
 
Answer
air sandbox run <name-of-graph>
air sandbox run <name-of-graph-pset>
 
0
Guest
 
 
Question
How do we extract data from client machine?
Rank Answer Posted By  
 Question Submitted By :: Ram
I also faced this Question!!   © ALL Interview .com
Answer
if u have to extract data from a database system (A) which 
is on server(B). for connecting to server(B) provide the 
username, encrypted password, connection method, 
servername, etc in ur .abinitiorc file and provide all the 
database(B) detail in ur .dbc file of ur component used for 
doing extraction (input table component).
 
0
Alok
 
 
Question
Do we really work with ACTUALDATA in development phase.
Rank Answer Posted By  
 Question Submitted By :: Ram
I also faced this Question!!   © ALL Interview .com
Answer
generally you will find development, QA and production 
phase. If all these 3 phases are there then in development 
phase u will never use actual data, but before moving the 
graph to prodution it needs to pass through QA where you 
have to test against the actual data.
 
0
Alok
 
 
Question
name the air commands in ab initio?
Rank Answer Posted By  
 Question Submitted By :: Abintioredhat
This Interview Question Asked @   Syntel
I also faced this Question!!   © ALL Interview .com
Answer
Here are the few of the commands we use 


1) air object ls <EME Path for the object -
 /Projects/edf/.. > --- This is used to see the listing of 
objects in a directory inside the project. 

2) air object rm <EME Path for the object -
 /Projects/edf/.. > -- This is used to remove an object 
from the repository. Please be careful with this. 

3) air object cat <EME Path for the object -
 /Projects/edf/.. > --- This is used to see the object 
which is present in the EME. 

4) air object versions -verbose <EME Path for the object -
 /Projects/edf/.. > --- Gives the Version History of the 
object. 

5) air project show <EME Path for the project -
 /Projects/edf/.. > --- Gives the whole info about the 
project. What all types of files can be checked-in etc. 

6) air project modify <EME Path for the project -
 /Projects/edf/.. > -extension <something like *.dat within 
single quotes> <content-type> --- This is to modify the 
project settings. Ex: If you need to checkin *.java files 
into the EME, you may need to add the extension first. 

7) air lock show -project <EME Path for the project -
 /Projects/edf/.. > --- shows all the files that are locked 
in the given project 

8) air lock show -user <UNIX User ID> -- shows all the 
files locked by a user in various projects. 

9) air sandbox status <file name with the relative path> ---
 shows the status of file in the sandbox with respect to 
the EME (Current, Stale, Modified are few statuses)
 
0
Puja Singh Srivastava
 
 
Question
What is the difference between a DB config and a CFG file?  
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Wipro
I also faced this Question!!   © ALL Interview .com
Answer
.db consists info   used by gde to connect to database 
.cfg consists info   used by co>op to connect to database
 
2
Guest
 
 
Answer
.cfg - > Database table configuration files for use with 
2.1 Database components

.dbc -> Database configuration files
 
0
Riman Bhaumik
 
 
Answer
Both .dbc and.cfg files are database configuration files.

The .cfg files are older version of database configuration 
files used with 2.1 database components.
 
0
Bharathi
 
 
Answer
db config gives details about the database configeration 
whereas cfg gives gives the entire configeration details
 
0
Guest
 
 
Question
Describe how you would monitor and control database 
physical file size and growth?
Rank Answer Posted By  
 Question Submitted By :: Guest
This Interview Question Asked @   Satyam , IBM
I also faced this Question!!   © ALL Interview .com
Answer
wc
 
0
Sam
 
 
Answer
throw co>op
 
0
Singh
 
 
Answer
connect as dba to the database and fire the query
show db_parameter_file; on oracle database (I am not sure 
on query, u can search for a similar query)
 
0
Alok
 
 
 
Back to Questions Page
 
 
 
 
 
   
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