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 Posted / lyubov podolskaya
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 ? | 24 Yes | 3 No |
Post New Answer View All Answers
What is publickey and private key?what is the use of this two keys?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
explain the environment varaibles with example?
You can ask about different vector functions. How to use in abinitio graph?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
What do you understand by overflow errors?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
Explain data flow graph with an example?
what is the project environment(for each project the environment is same or different to different project)?
what is the difference between i)public ii)private iii)common and client projects?
Mention what the difference between “look-up” file and “look is up” in abinitio?
What are the Types of parallelism in detail?
What are the operations that support avoiding duplicate record?