Answer Posted / subhash

SQL> small correct in Query provided by Kalpana.

SELECT COL1 FROM TAB1 WHERE COL1 IN
(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 the difference between the local container and shared container?

1141

---

To see hidden files in LINIX?

1584

---

Give an idea of system variables.

1085

---

Define Job control?

1223

---

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 ?

2074

---

What is orabulk stage?

1103

---

What are the different type of jobs in datastage?

1082

---

What is "fatal error/rdbms code 3996" error?

1340

---

project Steps,hits, Project level HArd things,Solved methods?

2182

---

On which Dimension Table you implemented SCD Type in your Project

2111

---

Can you explain tagbatch restructure operator?

1214

---

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

2323

---

how to sort two columns in single job in datastage.

2955

---

How to convert RGB Value to Hexadecimal values in datastage?

4052

---

What are the differences between datastage and informatica?

1226

---