Interested to Buy Any Domain ? << Click Here >> for more details...
lookup is passive y can't it be active?
let us say i have some records in my source like
101,rohit,1000
101,rohit,1000
102,kumar,2000
like wise
now as it is having multiple matches i return only
first,last value it can't return bouth the values
that means lookup is acting as select distinct right by
default what means it is active?
- 5 Answers
- 8249 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sarthak
Your Question is wrong......
this data belongs to Source table or look up table..
Multiple match principle comes in lookup table(not in source
table)..
if no. of rows in source table that connected to lookup t/f
is 3,then the output of lookup t/f is 3 rows...
it will not decrease
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is informatica worklet?
Explain load alternative records / rows into multiple targets - informatica
Explain pmcmd command usage in informatica
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Define sessions in informatica etl?
Explain lookup transformation source types in informatica
How many numbers of sessions can one group in batches?
How to generate sequence numbers without using the sequence generator transformation?
What does refresh system mean, and what are its distinctive choice?
What is sorter transformation?
Did u used latest transformations of 8.6.0? for what?
Different circumstance which drives informatica server to expel records?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
