What are the different layers in the information server architecture?

0 Answers  

---

EXPLAIN SCD

0 Answers   CTS,

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---

can explain wt is the pool for file.

1 Answers   CTS,

---

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

---

---

What are routines in datastage? Enlist various types of routines.

0 Answers  

---

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

---

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  

---

how can we do null handling in sequential files

2 Answers   Reliance,

---

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 is PX?

2 Answers   IBM,

---

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,

---