Answer Posted / sandipana

select rownum as rank,emp_id,sal from(select
lastname,salary from employees orderby salary desc)
where rownum IN(1,3,5);

Enlist the various types of transformations.

559

---

What is depict expression change?

618

---

What are batches?

623

---

How many number of sessions can one group in batches?

695

---

What is the function of look up transformation?

651

---

---

What is the format of informatica objects in a repository?

603

---

How do you handle two sessions in Informatica

669

---

Explain your project of banking domian.

1220

---

How to differentiate between the active and passive transformations?

627

---

 Informatica Checkpoints

2857

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1701

---

What is the commit type if you have a transaction control transformation in the mapping?

654

---

What is the difference between informatics 7x and 8x and what is latest version?

547

---

Did u used latest transformations of 8.6.0? for what?

1480

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1571

---