Answer / chandrasekar

Fact tables are normalized. Dimension tables are denormalized

Answer / hari prasad

fact tables contains normalized.

What is xml source qualifier transformation in informatica?

0 Answers  

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

How do you do error handling in Informatica?

1 Answers  

---

what is shared Cache. when we will use shared Cache?

4 Answers  

---

What are the different threads in DTM process?

1 Answers  

---

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers  

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

Clarify the aggregator change?

0 Answers  

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---