Answer / Vishwajeet Singh

Grant/Revoke DDL (Data Definition Language) facilities are used to manage permissions for creating, modifying, or deleting database objects. These facilities allow database administrators to control which users or groups can perform certain operations on the database.

In Ab Initio, the grant/revoke DDL facility is implemented using the GRANT and REVOKE commands:

- GRANT command: To grant permissions, use the following syntax: GRANT [PRIVILEGE] ON OBJECT TO USER; For example: GRANT ALTER TABLE ON mytable TO myuser.

- REVOKE command: To revoke permissions, use the following syntax: REVOKE [PRIVILEGE] ON OBJECT FROM USER; For example: REVOKE ALTER TABLE ON mytable FROM myuser.

what is different daily and monthly develop the abinitio graphs?

1 Answers   TCS,

---

Describe the effect of the "checkpoint" t-sql statement?

1 Answers  

---

How many parallelisms are in Abinitio?

3 Answers  

---

how to insert/update a csv file by comparing it with another csv file?

1 Answers  

---

What does de-partition mean in abinitio?

1 Answers  

---

What does dependency analysis mean in Ab Initio?

5 Answers   Syntel,

---

Can you read multiple input files using one input file component ?(same DML)

4 Answers   IBM,

---

What is the DynamicScriptGeneration and what is the Use?

2 Answers  

---

Hi friends, I have 100 records in my input file, if i run first,the first 10 records are stored into the output and if i run second time next 10 records stored into the output file like that please let me know the answer Thanks, krishna

5 Answers   CTS,

---

What parallelisms does Abinitio support?

1 Answers  

---

Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use

1 Answers   Wipro,

---

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1 Answers  

---