Answer Posted / ch naveen kumar

let the attribute name be abcabc and name be aaa and table
name be 1

insert into 2 abcabc from 1 where count(aaa)<5;

What happens when a session fails and you click on recover?

743

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1302

---

Write the program through which the records can be updated?

620

---

Where are the source flat files kept before running the session?

721

---

How to load the data from a flat file into the target where the source flat file name changes daily?

661

---

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2019

---

What are mapplets?

908

---

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

953

---

Explain incremental aggregation in informatica

746

---

Explain transaction control transformation in informatica

908

---

Sequence generator, when you move from develoment to production how will you reset

1525

---

What is sq transformation?

764

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1602

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

625

---

can we override a native sql query within informatica? Where do we do it?

736

---