Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6595 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
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How do you remove duplicate records in informatica? And how many ways are there to do it?
Describe the impact of several join conditions and join order in a joiner transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is the function of look up transformation?
What is an aggregator transformation?
What are the main features of Oracle 8i with context to datawarehouse?
What is fact table? Explain the different kinds of facts.
What are pre and post-session shell commands?
What are the different ways to implement parallel processing in informatica?
What do you understand by a term domain?
How can we use batches?
what is Active lock explain
what are the Methods For Creating Reusable Transformations?
