Answer Posted / poojitha

HI Mukesh,

Please drops the dumps to my mail id.
It would be a great help.

Thanks

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2030

---

Difference between Target-based loading and constraint-based loading?

1042

---

How many transformations can be used in mapplets.

1983

---

What is standalone command task?

1376

---

What is the advantage of informatica?

1126

---

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

2143

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1532

---

How we can create indexes after completing the load process?

1201

---

Different sorts of metadata that stores in the storage facility?

1070

---

lookup transformation with screenshots

4050

---

is it possible to index the data in cache of lkp transformation ?

2078

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1189

---

Explain the aggregator transformation?

1223

---

Is it possible to define a single node as a Gateway node as well as worker node?

1186

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2126

---