Answer / sujatha

Hi,

Hints are used to improve the query performance. Please go
through the below link ...u will get all the info
required...
http://www.adp-gmbh.ch/ora/sql/hints/index.html

Answer / usha

Hints is nothing but clues.
By using hints we can improve the query performence.

Answer / 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....

How are indexes created after completing the load process?

0 Answers  

---

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

What are the different options available for update strategy?

0 Answers  

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

what are the deliverables?in your project?

0 Answers   DELL,

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,

---

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---

How to Create a folder using pmrep command?

0 Answers  

---

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

---