Answer Posted / moorthy g

select count(1) from emp;

Count(1):
14
It will display how many records in emp table
Total 14 Records are there in my table.
Correct If I'm wrong
Regards,
Moorthy

Explain the features of connected and unconnected lookup.

640

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1777

---

Explain your project of banking domian.

1290

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1568

---

Explain direct and indirect flat file loading (source file type) - informatica

953

---

---

What is decode in static cache?

685

---

What is meant by LDAP users?

776

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1849

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2219

---

How to start a workflow using pmcmd command?

811

---

Explain Dataware house architecture .how data flow from intial to end?

2209

---

What are the mapping parameters and mapping variables?

716

---

What is the use of transformation?

657

---

what is the size of u r source(like file or table)?

1909

---

What is the benefit of partitioning a session?

740

---