Answer / nagaa

in sequential file set missing file mode to ok.by this we
can do exceptional handling in sequential file

Answer / venkatesh

we have the exceptio handler by using that one we cancall

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  

---

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

2 Answers  

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

---

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

---

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

---

Give an idea of system variables.

0 Answers  

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  

---

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

---

What all are the different way to run a job?

0 Answers  

---

How to convert RGB Value to Hexadecimal values in datastage?

0 Answers  

---