Answer / sanjeeva reddy

PIVOT STAGE

Answer / swetha

BY using Pivot stage convert rows into columns in
datastage.If we want to change in informatica we use
normalizer transformation.

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

What are the different database update actions available?

1 Answers   HP,

---

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,

---

what is main difference between change capture and change apply stages

4 Answers   IBM,

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---

Why we use surrogate key?

0 Answers  

---

How can you join flat file, oracle as a sources?

4 Answers   IBM,

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

What is apt_config in datastage?

0 Answers  

---

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  

---