Interested to Buy Any Domain ? << Click Here >> for more details...
I am having two tables,say table1 having cols
Empid,firstname,lastname,middlename and table2 having
Empid,firstname,lastname can i union them using Union t/f?
- 6 Answers
- 11531 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / pavana
Yes , we can created 2 input groups with 4 columns . For 1st
input group pass all columns from table 1 ,for 2nd input
group pass all 3 columns from table 2, 4th column from in
2nd group remain unconnected.
Session executes successfully. output will be the union of 2
tables. The 4th column from 2nd table will be populated as
null in output.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to delete duplicate row using informatica?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Mention few advantages of router transformation over filter transformation.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
State the limitations where we cannot use joiner in the mapping pipeline?
Define mapplet?
What are the different options available for update strategy?
What are the restrictions of union transformation?
How can we improve session performance in aggregator transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What are the advantages of informatica?
What differs when we choose the sorted input for aggregator transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is meant by LDAP users?
Explain in detail about scd type 1 through mapping.
