Answer / santhosh

sql override is used to write sql select statements
sql override contains in source qualifier transformation

we can use sql override when the source and target are
homogenious database
it will not support flatfiles and hedrogenious database

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,

---

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

What is olap (on-line analytical processing?

0 Answers  

---

What are the types of lookup?

3 Answers   Wipro,

---

---

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

---

how do u move the code from development to production?

3 Answers  

---

can we use bulk loading when we use look in mapping

1 Answers   TCS,

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---

What is informatica? What exactly are the practical uses in real world

2 Answers  

---