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
- 8434 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
To import the flat file definition into the designer where should the flat file be placed?
On which transformations you created partitions in your project?
What is enterprise data warehousing?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Differentiate between a database and data warehouse?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain load alternative records / rows into multiple targets - informatica
Explain pmcmd command usage in informatica
Explain pushdown optimization $pushdownconfig parameter - informatica
In informatics server which files are created during the session rums?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to update or delete the rows in a target, which do not have key fields?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How do you load only null records into target? Explain through mapping flow.
