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?
Answer Posted / ganithi anil
for union t/f tables structures should be same, i mean
columns and data types should besame then only you use
union t/f
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to do unit testing in informatica?
what is index?how it can work in informatica
How can we update a record in the target table without using update strategy?
How do you convert single row from source into three rows into target?
How can you validate all mappings in the repository simultaneously?
How many dimensions are there in informatica?
list out all the transformations which use cache?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Which is the t/r that builts only single cache memory?
How to update a particular record in target with out running whole workflow?
What is update strategy transform?
design of staging area?
Have you worked with/created Parameter file
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the differences between joiner transformation and source qualifier transformation?