Explain the difference between a data warehouse and a data mart?

0 Answers  

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

---

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

Define pmcmd command?

0 Answers  

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

---

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

---

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

---