Answer / chandrasekar

DISTINCT is used to display the unique records.

Answer / sudhakar

it will shown single time.
ex:-in accounts dept have 10 employees.
naturally
employee dept
sai acccouts
sudhakar accounts
ramesh accounts
etc.... upto 10members

like distinct show
department show single time
Employee Dept
10 accounts

Answer / amol m

Distinct keyword is used to eliminate duplicate records and
showing only single one.

Answer / alok

SELECT distinct * FROM STUDENT;

need for registering a repository server

1 Answers  

---

What is meta data and system catalog?

2 Answers  

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

---

In a sequential batch can you run the session if previous session fails?

4 Answers  

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

explain about lookup t/r?

1 Answers   IBM,

---

Tell me about MD5 functions in informatica

0 Answers  

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---