Answer Posted / rayudu

hi,


Flat file doesn't contain any indexes or keys so it will
directly load into it. whereas in a table it will first
check for indexes and keys while loading into table so it is
slow when compared to flat file loading.



Regards,
rayudu.

how to load dimension table and fact table. plz tell me the steps.

1899

---

Define enterprise data warehousing?

900

---

What is mapplet in informatica?

806

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1728

---

Under which circumstances, informatica server creates reject files?

863

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2007

---

What do mean by local and global repository?

969

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1755

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

812

---

Describe the impact of several join conditions and join order in a joiner transformation?

865

---

What is the commit type if you have a transaction control transformation in the mapping?

867

---

Tell me about Propagate functions in informatica

741

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1697

---

Can u generate reports in Informatica?

872

---

Explain what are the different versions of informatica?

901

---