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
- 6613 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 join three sources using joiner?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Which transformation is needed while using the Cobol sources as source definitions?
What is the use of target designer?
Where do we use mapping variables in informatica?
What is update strategy transform?
How to use pmcmd utility command?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the tasks that source qualifier perform?
In development project what is the process to follow for an etl developer from day1
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the maplet?
How to use procedural logic inside infromatica?
whats the logic to load the lower level of granularity of data to fact table.
What is the use of transformation?
