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;

What are mapplets?

0 Answers  

---

Mention a few design and development best practices for informatica?

0 Answers  

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

---

what is song in infrmatica...?

0 Answers   CTS,

---

What do you understand by SOA of Informatica?

0 Answers  

---

---

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

---

What is joiner transformation in informatica?

0 Answers  

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

How can you generate reports in informatica?

0 Answers  

---