Interested to Buy Any Domain ? << Click Here >> for more details...
How can we get multiple output values using an unconnected
lookup transformation?
- 2 Answers
- 16714 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / atul pitroda
This should be simple enough to concate the values with
delimeters and deconcate at the receiver end.
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / viswanath
Lookup transformation from Informatica 9x version can be
configured as an Active Transformation...
To use this option, while creating the transformation, we
must configure the Lookup transformation property "Lookup
Policy on Multiple Match" to Use All Values. Once created
we cannot change the mode between passive and active. When
ever the Lookup policy on multiple match attribute is set
to Use All Values. The property becomes read-only.
However, this is not possible for an Unconnected Lookup. We
may have to use the same old procedure of returning single
value by conctinating the required fields by a delimiter..
| Is This Answer Correct ? | 2 Yes | 1 No |
Explain joiner transformation in informatica
Can i create a lookup table without cache.
What are mapplets? How is it different from a Reusable Transformation?
What is the use of target designer?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Explain the difference between a data warehouse and a data mart?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
What are the types of data that passes between informatica server and stored procedure?
Teradata 
