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
- 30204 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
Is data warehousing different from data mining?
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
Explain about ab initio’s dependency analysis?
What are the six data process products of ab initio (architecture of ab initio)?
Can you explain the co>operating system’s processing model?
Explain the methods to improve performance of a graph?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
explain the environment varaibles with example?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
What are the operations that support avoiding duplicate record?
How to run a graph infinitely?
When we should use 'jobid' for commit table (Output table component??
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
How abinitio eme is segregated?
How can you force the optimizer to use a particular index?
