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
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 is the fact table?
Define sessions in informatica etl?
What is an Integration service in Informatica?
How can we remove the duplicates from flat file source?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Which are the different editions of informatica powercenter that are available?
How do you migrate data from one environment to another?
Scheduling properties,whats the default (sequential)
What is depict expression change?
What is mapplet in informatica?
What is target load order?
Reusable transformation and shortcut differences
Explain pushdown optimization and types in informatica
What is sorter transformation?
Differentiate between a database and data warehouse?