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
- 9390 Views
- Accenture, I also Faced
- E-Mail Answers
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
Enlist the various types of transformations.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Performance tuning( what you did in performance tuning)
Differentiate between sessions and batches?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Define enterprise data warehousing?
Briefly define a session task?
Explain the aggregator transformation?
can we override a native sql query within informatica? Where do we do it?
Differentiate between router and filter transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are multi-group transformations?
How you prepared reports for OLAP?
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?
What do you mean by channel change?
