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
- 11074 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
Explain sessions?
Make a note of the quantity vaults made in informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
r u done any partitions in ur project?
What is the difference between a repository server and a powerhouse?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
can u any challenge your project?
How would you join a node to the already existing domain?
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain constraint based loading in informatica
Explain pushdown optimization and types in informatica
What is enterprise data warehousing?
difference between informatica 8.1.1 and 8.6
Explain about cumulative Sum or moving sum?
Why do we need informatica?
