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
- 6800 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 you prepared reports for OLAP?
How can you differentiate between powercenter and power map?
How might you approve all mappings in the archive all the while?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are the different components of powercenter?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Is there any target staging area in informatica not staging area
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How can we create index after completion of load process?
Explain pmcmd command usage in informatica
can we override a native sql query within informatica? Where do we do it?
What is the cumulative sum and moving sum?
What if the source is a flat-file?
How will the document be delivered to me?
