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
- 6699 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
Explain the pipeline partition with real time example?
Where do we use mapping variables in informatica?
What is DR strategy for Informatica project?
Differentiate between router and filter transformation?
Can we create a Integration service without a Repository service and vice versa?
What are the components of the workflow manager?
What is the session task and command task?
Can u generate reports in Informatica?
Which files are created during the session rums by informatics server?
Explain how to import oracle sequence into informatica?
How can repository reports be accessed without sql or other transformations?
How to differentiate between the active and passive transformations?
What are the data movement modes in informatica?
What is the surrogate key?
What is the fact table?
