Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / soujanya
used to perform dml operations such as insert update delete
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain pmcmd command usage in informatica
What is the sql query overwrite in source qualifier in informatica
What are the different clients of powercenter?
Explain joiner transformation in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
list out all the transformations which use cache?
Describe an informatica powercenter?
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 can we create index after completion of load process?
I have a flat file, want to reverse the contents of the flat file
What happens when a session fails and you click on recover?
Differentiate between joiner and lookup transformation?
what is $$$$?
Repository user profiles
Write the unconnected lookup syntax?
