Answer Posted / keerthika

We can use like

out.field1 :: lookup("LOOKUP_FILE_NAME".Key).Field1_to_be_fetched;
out.field2 :: lookup("LOOKUP_FILE_NAME".Key).Field2_to_be_fetched;

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?

963

---

What do you mean by a transaction file?

1188

---

Explain how abinitio eme is segregated?

1445

---

Explain what is sort component in abinitio?

1060

---

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1033

---

What is common among data validity and data integrity?

1008

---

When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

2400

---

Can you explain the performance and scalability of co> operating system?

1080

---

Have you worked with packages?

1163

---

Describe in detail about lookup?

1042

---

What parallelisms does Abinitio support?

1162

---

What is publickey and private key?what is the use of this two keys?

2849

---

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

1670

---

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

1086

---

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1393

---