Mention few advantages of router transformation over filter transformation.

0 Answers  

---

What are the Advantages of de normalized data?

3 Answers  

---

Repository user profiles

0 Answers  

---

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

How we can confirm all mappings in the repository simultaneously?

1 Answers  

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,

---

can we override a native sql query within informatica? Where do we do it?

0 Answers  

---

What is a data modeling?

2 Answers  

---