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


Please Help Members By Posting Answers For Below Questions

What is the fact table?

806


Define sessions in informatica etl?

802


What is an Integration service in Informatica?

915


How can we remove the duplicates from flat file source?

807


hi real timers . iam waiting for ur reply regarding ETL TESTING

2058


Which are the different editions of informatica powercenter that are available?

824


How do you migrate data from one environment to another?

874


Scheduling properties,whats the default (sequential)

1704


What is depict expression change?

823


What is mapplet in informatica?

797


What is target load order?

1029


Reusable transformation and shortcut differences

1611


Explain pushdown optimization and types in informatica

877


What is sorter transformation?

806


Differentiate between a database and data warehouse?

919