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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 i can implemate Insert,Update,delete in abinitio?
how will u view MFS in unix?what is diff/btween conditional 
dml& conditional component?
 Question Submitted By :: Veluruabinitio
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?
Answer
# 1
it will solve lookup and replicate just write query yes/no
 
Is This Answer Correct ?    2 Yes 4 No
Veluruabinitio
[Boolean Value]
 
  Re: how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?
Answer
# 2
to find records which should be inserted , updated or
deleted one should use ab initio flow 
a. unload master table
b. read delta file 
c. use inner join to join a and b unused a will be your
delete records (if required) unused b will be your insert
record . joined a and b will be your update records

to view MFS in unix you should run m_expand command
conditional DML can be pass as program variable 
conditional components will be used only when condition past
to the graph is true
 
Is This Answer Correct ?    5 Yes 0 No
Lyubov Podolskaya
 
 
 

 
 
 
Other Ab Initio Interview Questions
 
  Question Asked @ Answers
 
How might you quantitatively measure an improvement made to a query?  1
what is the relation between EME , GDE and Co-operating system ?  4
How many parallelisms are in Abinitio?  2
how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component? IBM2
Describe how you would monitor and control database physical file size and growth? Satyam3
what are kinds of layouts does ab initio supports ?  3
what does layout means in terms of Ab Initio?  3
How to Improve Performance of graphs in Ab initio?  2
I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how is in Type 1 and how is it on type 2? IBM1
What does dependency analysis mean in Ab Initio? Syntel2
what is skew and skew measurement?  1
name the air commands in ab initio? Syntel1
How to Create Surrogate Key using Ab Initio?  3
what is the difference between .dbc and .cfg file?  2
what is deeup in unique only? IBM3
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
Graph was failed how it is achived ? send answer with phone number? i want speak with directly who is intrest on abinitio? HCL1
What are Cartesian joins?  2
How can we RUN a graph in UNIX?  3
 
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