Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

How can we run same job in 1 day 2 times

7 Answers   IBM,

---

Define oconv () and iconv () functions in datastage?

0 Answers  

---

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

What are routines in datastage?

0 Answers  

---

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

---

Describe link sort?

0 Answers  

---

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,

---

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

4 Answers   TCS,

---

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,

---