Answer / avijit

Create the functionality by using the components.
Make sure that everything is parameterized in the components so that it becomes generic.
create the sub-graph from the components from this and publish it as component.

once published you can use the same as component in any of your graphs.

How can you force the optimizer to use a particular index?

1 Answers  

---

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?

1 Answers  

---

What is EME?What is GDE?What is Co-operating system?What is the link between all these?Please explain elaborately.

1 Answers  

---

How can you achieve scan using reformat ?

2 Answers  

---

How does PBK and Sort component and Join(in memory sort) work?I mean in the join component i have used In Memory Sort,so how will it work in terms of performence as compared with PBKand Sort Component?

1 Answers  

---

In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?

2 Answers   IBM, TCL,

---

Mention some ways for improving performance of a graph?

1 Answers  

---

What is the difference between a scan component and a rollup component?

1 Answers  

---

Need Ab-Initio Material - Harini

7 Answers  

---

Have you used rollup component? Describe how.

1 Answers  

---

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

1 Answers  

---

what is the difference between the .dbc and .cfg extensions and give any clear information ?

4 Answers   Cognizant,

---