Answer / lisa

I can add one dummy column to both the tables with value '1' and join both the tables on the basis of that dummy column. But how to do the join when there are huge number of columns/huge data volume in the tables? Please reply!

What is the difference between view and materialised view?

4 Answers  

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

---

What is the scenario which compels informatica server to reject files?

0 Answers  

---

Design a mapping to load a target table with the following values from the above source?

0 Answers   Informatica,

---

where to select code page option?

2 Answers   TCS,

---

Can we override a native sql query within informatica?

0 Answers  

---

What are junk dimensions?

0 Answers  

---

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

---

What are the mapping paramaters and mapping variables?

1 Answers  

---

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

---

What is a command that used to run a batch?

4 Answers  

---