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
- 5820 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
Clarify the utilization of aggregator cache record?
What are pre and post-session shell commands?
What is lookup change?
What are the advantages of informatica?
Differentiate between joiner and lookup transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
How an expression transformation differs from aggregator transformation?
Define filter transformation?
What are the components of workflow manager?
expain about the tune parameters?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Separate from a database, an information bazaar, and an information stockroom?
What is the surrogate key?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to create Target definition for flat files?
