what is lookupoverriding?
Answer / mansi
We can override the lookup query for a relational lookup.
We can enter the entire override, or we can generate and
edit the default SQL statement.
Override the lookup query in the following circumstances:
1.Override the ORDER BY statement
2.A lookup table name or column names contains a reserved
word
3.Use mapping parameters and variables
4.A lookup column name contains a slash (/) character
5.Add a WHERE statement
Is This Answer Correct ? | 2 Yes | 0 No |
What is session task and command task?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
How to delete the data in the target table after loaded.
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
What is the Difference between DSS & OLTP?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
What is the status code?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690