Answer / haseeb

Mapping programs are executed on the Integration Server, where they can access the global value-mapping table and mapping runtime constants. In addition, calls to other application systems are sometimes necessary to meet the following requirements:
To get read access to application system data in the mapping program
To call existing mapping routines in the application system

What is the purpose of pivot stage and types of containers in datastage

0 Answers  

---

hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer 

1 Answers   HCL,

---

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

---

What is APT_DUMP_SCORE?

2 Answers   IBM,

---

How to reverse the string using SQL?

0 Answers   CTS,

---

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

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  

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---

what r the sources u need to create the datastage?

1 Answers  

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

---