3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

---

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---

What are system variables and sequencers in datastage

0 Answers  

---

Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

---

What is the difference between hashfile and sequential file?

0 Answers  

---

What are the processing stages?

0 Answers  

---

why do u need the IOS upgradation in a FC switch

0 Answers   IBM,

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

---

What is ibm datastage flow designer?

0 Answers  

---

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,

---

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

---

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,

---