Answer Posted / kalpana_241871

SQL>

SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) > 1 ;

O/P 1 :
1
1
1
2
2
2
3
3
SQL>

SELECT COL1 FROM TAB1 GROUP BY COL1 HAVING COUNT(*) = 1 ;

O/P 2 :
4
5
6

What is ds designer?

1030

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3604

---

What are the different plug-ins stages used in your projects?

1026

---

Is the value of staging variable stored temporarily or permanently?

929

---

What is the flow of loading data into fact & dimensional tables?

1011

---

What are the differences between datastage and informatica?

1109

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2207

---

Have you used Unstructured data?

1266

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

886

---

Can you explain link buffering?

1104

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2094

---

table actions available in oracle connector?

1553

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1962

---

Where do you see different stages in the designer?

1034

---

what is the use of surogate key in datastage

2246

---