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
Define sessions in informatica etl?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is depict expression change?
How are indexes created after completing the load process?
How to create a non-reusable instance of reusable transformations?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are some examples of informatica etl programs?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
While migrating the data from one environment to another environment how would you manage the connections?
How we can use union transformation?
what are the Methods For Creating Reusable Transformations?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are session parameters ? How do you set them?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.