what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 Answers  

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---

What are the informatica performance improvement tips

0 Answers   Informatica,

---

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---