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
- 31505 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 is a data flow graph?
What are the different types of parallelism used in abinitio?
What are the six data process products of ab initio (architecture of ab initio)?
What is abinitio?
Why might the optimizer use a table scan when an index is available?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What is sandbox?
What do you know about partition and also tell us about partition components in abinitio?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What metadata importer can do in ab initio?
Mention what is the syntax for m_dump in abinitio?
Have you used rollup component? Describe how.
What is a rollup component?
Why is data processing considered beneficial?
What is the difference between partitioning with key / hash and round robin?
