Answer / rajendra

Hi everybody

A Dimension which is shared bu multiple fact Tables
is known as Conformed Dimension.

Answer / ramesh

fact is a measure and methods of data is confirmed in
datawarehousing

To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

difference between stop and abort

2 Answers  

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

What is a passive transformation?

0 Answers   Informatica,

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

---