Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / usha
This Transformation is used to perform DML operation for
the already data populated target.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain the difference between a data warehouse and a data mart?
What are the components of the workflow manager?
What are the data movement modes in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Explain the different dimensions.
As union transformation gives UNION ALL output, how you will get the UNION output?
How many number of sessions can one group in batches?
What is repository manager?
In informatics server which files are created during the session rums?
permutations of mapplet
What do think which one is the better joiner or look up?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
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
What are data-driven sessions?
What differs when we choose the sorted input for aggregator transformation?
