Answer / amit trivedi

We need to use external tables to join a flat file and oracle table.
First insert all records of flat file into an external table and then join these two tables.

else, use next step, insert data from external table to oracle table and join these two tables using join conditions.

Answer / lokesh

first we need to converted flat files in tables ofter join
the oracle and that table

Is possible to create skid in dim,fact tables?

1 Answers   NTT Data,

---

i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 Answers  

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1 Answers  

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

---

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

---

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1 Answers  

---

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

---

What is active and passive stage?

1 Answers  

---