what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

How to reverse the string using SQL?

0 Answers   CTS,

---

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  

---

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

---

What is the difference between Link collector and Funnel Stages?

1 Answers  

---

What is the use of surrogate key stage?

2 Answers  

---

Name the third party tools that can be used in datastage?

0 Answers  

---

What are the different common services in datastage?

0 Answers  

---

what is the use of materialized view?

0 Answers   CTS,

---

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,

---

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  

---