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
- 6715 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
How to do unit testing in informatica? How to load data in informatica ?
Sequence generator, when you move from develoment to production how will you reset
What is target designer and target load order?
How to improve the performance of a session using sorter transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
If informatica has its scheduler why using third party scheduler?
What are the new features of Power Center 5.0?
How can we use mapping variables in informatica?
Is there any way to read the ms excel datas directly into informatica?
Briefly describe lookup transformation?
I have a flat file, want to reverse the contents of the flat file
Why sorter is an active transformation?
Explain the aggregator transformation?
Why update strategy and union transformations are active?
Target increases every day even though no new record was inserted
