Answer Posted / gazulas

by using hints we can direct the optimizer to follow what was specified in the hints. ex: we can direct the optimizer to do a index unique scan instead of full table scan....

What is meant by query override?

1055

---

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?

1971

---

what is the complex transformation you used in informatica

2585

---

What is option by which we can run all the sessions in a batch simultaneously?

1137

---

explain abt ur project architecture?

2186

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1577

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2031

---

What are the features of complex mapping?

1151

---

What is workflow? What are the components of the workflow manager?

1131

---

Explain the difference between a data warehouse and a data mart?

1056

---

How do you load only null records into target?

1212

---

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?

1489

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2063

---

What are the tuning techniques you applied during your last project

2022

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2352

---