Answer / shashiall

Run the procedure to load the ttime dimension.Its not
loaded frequently,but once or twice a year.

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---

What are the restrictions of union transformation?

0 Answers  

---

---

How many joins in Informatica

5 Answers   CSC,

---

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

---

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

what is index?how it can work in informatica

0 Answers  

---

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---