Answer Posted / bala

In Windows we can create only one Repositor.
We may create more than one in unix\Linux Platforms.
(What i Read i am giving)

How can we create index after completion of load process?

1125

---

What are the different types of transformation available in informatica.

1105

---

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

2122

---

How can you validate all mappings in the repository simultaneously?

1372

---

How can repository reports be accessed without sql or other transformations?

1223

---

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

2094

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2038

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1667

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1506

---

What is a shortcut and copy in Informatica and how two are different with each other?

1199

---

Explain how to import oracle sequence into informatica?

1020

---

During the running session, output files are created by informatica server. Enlist few of them.

982

---

Can we override a native sql query within informatica?

1041

---

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.

1281

---

Can we get 1st record through Informatica(without sequence number).

1479

---