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
- 31156 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 |
Can you explain the performance and scalability of co> operating system?
what is different daily and monthly develop the abinitio graphs?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?
What does it mean by the term 'sort component'?
Can anyone give me an exaple of realtime start script in the graph?
Describe which system or process elements you would review when trouble-shooting general server slows ?
Can you use scan to generate sequence number ? How to use in abinitio graph?
Code check-in and check-out commands in AbInitio
What do you mean by the term data warehousing?
What do you know about abinitio?
what is the difference between .dbc and .cfg file?
Teradata 
