Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is the hint?
how to use it to reduce the query processing in program?

Question Posted / teja_dwh

Answers were Sorted based on User's Feedback



what is the hint? how to use it to reduce the query processing in program?..

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

Is This Answer Correct ?    0 Yes 0 No

what is the hint? how to use it to reduce the query processing in program?..

Answer / usha

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

Is This Answer Correct ?    2 Yes 2 No

what is the hint? how to use it to reduce the query processing in program?..

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

what is the complex transformation you used in informatica

0 Answers   TCS,

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories