Answer Posted / shankar

if there is primary key there then this cant be done. we get an error 'unique constraint violated'error. hence very less scope here. if we can assign any i.d then there might be some scenarios where we can do this.

What are the reusable transformations?

1155

---

How to Create a folder using pmrep command?

1173

---

Differentiate between reusable transformation and mapplet.

1086

---

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.

1631

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1786

---

What are the prerequisite tasks to achieve the session partition?

1248

---

how many types of dimensions are available in informatica?

1088

---

What does cheating measurement mean?

1045

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2552

---

What is the benefit of session partitioning?

1111

---

What is session task and command task?

1286

---

Define pmcmd command?

1037

---

What is informatica metadata and where is it stored?

989

---

list out all the transformations which use cache?

1180

---

Why do we need informatica?

985

---