Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql override?what is the use of it?
- 4 Answers
- 16233 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / soujanya
It is a process of writing user defined SQL queries to
define SQL joins,source filters, sorting input data and
eliminating duplicates
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
explan ur project architecture?
What is meant by incremental aggregation?
How we can create indexes after completing the loan process?
What is rank index in rank transformation?
Can we create multiple integration service on single repository?
Explain sessions and how many types of sessions are there?
What are active and passive transformations?
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
How would you join a node to the already existing domain?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is exclusive and normal mode for repository services?
How to do unit testing in informatica?
Name the different lookup cache(s)?
what is the hint? how to use it to reduce the query processing in program?
What is native users?
