Answer / ravikumar2614

Fact table having huge data with less colomns..

Answer / davankumar

Fact table has the big data bcoz fact table main tain
history data.

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

What is olap (on-line analytical processing?

0 Answers  

---

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

---

What is query panel?

1 Answers  

---

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

---

---

Explain the scenario which compels informatica server to reject files?

0 Answers  

---

r u done any partitions in ur project?

0 Answers   TCS,

---

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,

---

what is unique constraint error ?

2 Answers   TCS,

---

What are the performance considerations when working with aggregator transformation?

0 Answers  

---

what is lookup chache?

1 Answers   Patni,

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---