Answer / chamanvir kaur

Set the key as NULL - {}

Answer / sai

Keep Key is Null you can get cross join

Answer / nandini

you can use join component with parameter join type “inner join” as cross join is reduced form of inner join given where clause.

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?

0 Answers  

---

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

0 Answers  

---

Explain the ab initio etl tool in high level?

0 Answers  

---

What is broadcasting and replicate?

0 Answers  

---

Order of Evaluation of Parameters

2 Answers  

---

What are the six data process products of ab initio (architecture of ab initio)?

0 Answers  

---

I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

0 Answers  

---

from a graph how to select only second record always in scan?

3 Answers   IBM,

---

Have you used rollup component? Describe how.

0 Answers  

---

What information does a .dbc file extension provides to connect to the database?

0 Answers  

---

what is the difference between .dbc and .cfg file?

3 Answers   Cap Gemini,

---

I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how is in Type 1 and how is it on type 2?

5 Answers   CTS, IBM,

---