Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 31492 Views
- IBM, Syntel, I also Faced
- E-Mail Answers
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 local and formal parameter?
What is the purpose of having stored procedures in a database?
What is de-partition in abinitio?
What do you understand by a cartesian join?
What is $mpjret?
The methods to improve performance of a graph?
What are the types of data processing you are familiar with?
How to move or copy the project parameter or project object to my sandbox?
Do you know what a local lookup is?
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...................................
What are the Types of parallelism in detail?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Why might you create a stored procedure with the with recompile option?
How can you force the optimizer to use a particular index?
What is the difference between look-up file and look-up, with a relevant example?
