Answer Posted / arpita

A dimension which cannot be used to indicate the key
performance indicators is known as junk dimension.....
eg: Address,Phone number,Faxno,Description......etc...

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)

1073

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

534

---

What is the sql query overwrite in source qualifier in informatica

611

---

what is the size of your data warehousing?

1667

---

Explain the aggregator transformation?

621

---

---

how we can load rejected record's at run time?(not through bad files)

1904

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4959

---

What is the fact table?

580

---

What is a router transformation?

618

---

What is xml source qualifier transformation in informatica?

707

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4764

---

Define mapping and session?

577

---

What is a transaction control transformation?

759

---

How can we remove the duplicates from flat file source?

569

---

What are the performance considerations when working with aggregator transformation?

669

---