what is the hint?
how to use it to reduce the query processing in program?
Answer Posted / usha
Hints is nothing but clues.
By using hints we can improve the query performence.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is the size ur source like(file system or database)? how many record daily come u r banking project?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Can we get 1st record through Informatica(without sequence number).
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain sessions?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is parallel processing in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Why union transformation is an active transformation?
How many dimensions are there in informatica?
Why do you use Mapping Parameter and mapping variable?
What is sorter transformation?