if suppose i have 3 columns namely 1,2,3 in table a and
1,2,3 in table b Now in table a 1,2 and table b 1,2 columns
are having same data.now based on this two columns either
data should get inserted or updated. How do i write a sql
query to check whether the data is populated correctly or
not
- 2 Answers
- 6265 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sri
Write Tablename.columnname in SQL query. In your case,
for selecting all data from table a column 2,the query is:
select * from a.2
So in this way operation of data can be made by using
required SQL operators.
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
What are the uses of etl tools?
What do you mean by blocking transformation?
What is informatica etl tool?
What is Session and Batches?
Explain the types of transformations?
Global and Local shortcuts. Advantages.
What are the differences between oltp and olap?
Explain the tuning lookup transformation - informatica
What does command task mean?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what is $$$$?
What are mapplets?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain joiner transformation in informatica
What is a connected transformation?
