Answer Posted / jagan

A Factless fact table captures the many-to-many
relationships between dimensions,but contains no numeric or
textual facts.

Explain transaction control transformation in informatica

1229

---

difference between repository database and repository service?

1109

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2160

---

How many dimensions are there in informatica?

1052

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8158

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1893

---

What is a difference between complete, stop and abort?

1048

---

What is a passive transformation?

1058

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1147

---

What is the benefit of partitioning a session?

1127

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1947

---

Tell me about Propagate functions in informatica

894

---

Explain the different lookup methods used in informatica?

994

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1073

---

Explain constraint based loading in informatica

1059

---