Answer Posted / sanjay

While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.

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

794

---

What is the maplet?

696

---

What is the difference between stop and abort in informatica

759

---

Where do we use mapping variables in informatica?

705

---

Explain in detail scd type 2 through mapping.

730

---

---

How to extract sap data using informatica? What is abap? What are idocs?

674

---

I have a flat file, want to reverse the contents of the flat file

787

---

Different circumstance which drives informatica server to expel records?

634

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1763

---

In development project what is the process to follow for an etl developer from day1

1370

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1776

---

What is the scenario which compels informatica server to reject files?

707

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1411

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1738

---

Explain informatica architecture - version 8 / 9

757

---