Answer / kishor baindoor

a) source can be Flat files , Cobol Files , Oracle table etc
b) Fact table will be having main data where as dimention
ttable describes attributes of fact table. primary keys for
ddimentional table will foreign key of fact table. go
through dimentional modelling.

tell me the rules and responsblites in our project(my project is development)

0 Answers  

---

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

Mention few power centre client applications with their basic purpose?

0 Answers  

---

what is distinct

4 Answers  

---

---

why u go for dimensions ?

3 Answers   TCS,

---

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---

What do you mean by channel change?

0 Answers  

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  

---