Answer Posted / jvdwhinfo

Using Seq. generator we can delete the desired record from
flat file.

Please let me know if you have any suggestions.

Thanks,
James

Mention some types of transformation?

1094

---

What are the types of schemas we have in data warehouse.

1004

---

What is data transformation manager process?

1220

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2054

---

Difference between Data and Index Caches?

1198

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2121

---

Write the unconnected lookup syntax?

1129

---

How can a transformation be made reusable?

1223

---

What is the difference between a connected look up and unconnected lookup?

1000

---

What are junk dimensions?

1111

---

How many ways a relational source definition can be updated and what are they?

1061

---

Differentiate between Load Manager and DTM?

2208

---

What is dynamic cache?

1085

---

Performance tuning in UNIX for informatica mappings?

2621

---

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

2595

---