Answer Posted / praveen

fact less fact table is nothing but.......
Fact table consists only s.k's nothing other than sk's...

Example::
Students Attendtance... It consists only student
information nothing other than present or absent..i.e
Boolean values(Yes or No)

Where are the source flat files kept before running the session?

1140

---

What is a difference between complete, stop and abort?

1125

---

what is the Default Source Option For Update Strategy Transformation?

1287

---

How do you load only null records into target?

1254

---

What is the status code in stored procedure transformation?

1234

---

Enlist the various types of transformations.

1122

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1680

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2171

---

What are the new features of Power Center 5.0?

1848

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1339

---

What does command task mean?

1217

---

Briefly describe lookup transformation?

1097

---

How do you migrate data from one environment to another?

1149

---

Define filter transformation?

1149

---

How can you define user defied event?

1076

---