Answer Posted / dl

fOLLOWING are the set operators in oracle
UNION
UNION ALL
MINUS
INTERSECT

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1267

---

How to handle decimal places while importing a flatfile into informatica?

1187

---

Can u generate reports in Informatica?

1075

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1027

---

Does an informatica transformation support only aggregate expressions?

1031

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2137

---

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2153

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1948

---

What is decode in informatica?

1143

---

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.

1627

---

How is union transformation utilized?

1003

---

Define update strategy?

1210

---

Write the unconnected lookup syntax?

1078

---

What is session task and command task?

1282

---

Explain the mapping variable usage example in informatica

1151

---