Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / moorthy g
NEWLOOKUPROW
Note: We can't edit the port:
NEWLOOKUPROW = 0 (No Changes)
NEWLOOKUPROW = 1 (Insert)
NEWLOOKUPROW = 2 (Update)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is informatica? Why do we need it?
Explain sessions?
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
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Explain lookup transformation is active in informatica
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Can we create a Integration service without a Repository service and vice versa?
How do you change a non-reusable transformation to reusable transformation?
What is a standalone command task?
What is the procedure for creating independent data marts from informatica 7.1?
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 are the sources and targets definitions imported in informatica designer?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Explain about cumulative Sum or moving sum?
