Answer / chandrasekar

Fact tables are normalized. Dimension tables are denormalized

Answer / hari prasad

fact tables contains normalized.

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

---

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

---

---

what is index?how it can work in informatica

0 Answers  

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

How to go to the older version for a mapping?

0 Answers  

---

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---