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
- 28990 Views
- IBM, Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / r.sekhar
u can do using update table component.In this we can connect
the database using .dbc i.e. database configure file, and
then browse the table ten convert to output file component
using same dml. then that component to update table
component. then we can change the data in the input
component like update table using sql quarry panel ...
We can also do delete from the table using same sql quarry
in the dml...
using truncate component we can do truncate a table also..
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / veluruabinitio
it will solve lookup and replicate just write query yes/no
| Is This Answer Correct ? | 3 Yes | 21 No |
What do you understand by a cartesian join?
How is the partitioning with key different from round robin partition?
How will you use EME for view or publish metadata reports using EME?
how to prepare scd2 in abinitio
Difference between informatica vs ab initio?
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
How can we RUN a graph in UNIX?
What is air-project parameter ? How to use in abinitio graph?
3 Answers IBM, TCL, Tech Mahindra,
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
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 creation of temporary files depends on the value of MAX CORE
If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.
Teradata 
