Interested to Buy Any Domain ? << Click Here >> for more details...
1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
- 4 Answers
- 13148 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / tanay
1.We use unconnected transformation to use multiple number
of tables or views without physically taking the entity
into mapping.This kind of transformation is also helpful
when single return port is required.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Tell me about MD5 functions in informatica
What is Index Caches size?
Explain joiner transformation in informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Can you generate sequence numbers without using the sequence generator transformation?
Partition, what happens if the specified key range is shorter and longer
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what is diff b/t sorter t/r and agg have the option sorter property...
How we can create indexes after completing the loan process?
What is the difference between Active and Passive transformation?
Do you find any difficulty while working with flat files as source and target?
Mention a few design and development best practices for informatica?
Which development components of informatica have the highest usage?
What is an unconnected transformation?
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
