Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  

---

What are the types of views in datastage director?

0 Answers  

---

How a server job can be converted to a parallel job?

0 Answers  

---

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

---

What are the types of containers in datastage?

0 Answers  

---

Could anyone give brief explanation bout datastage admin

0 Answers  

---

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

---

job locking methods? How can we unlock the job?

3 Answers   IBM,

---

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

---

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

8 Answers   L&T,

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

Is it possible to query a hash file?

0 Answers   IBM,

---