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
- 6596 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / misra
Select a.*,b.*,'update' as type
from a,b where a.1=b.1 and a.2=b.2
union
Select a.*,b.*,'insert' as type
from a,b where a.1<>b.1 or a.2<>b.2
Basically its like scd1,with table A as source and table B as target.
Based on "type" column you can write insert/update statement in stored procedure at db level or keep update strategy in informatica level.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
When the informatica server marks that a batch is failed?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
What are the reusable transformations?
What is the main difference between a Joiner Transformation and Union Transformation?
What does update strategy mean, and what are the different option of it?
How the facts will be loaded? explain
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is enterprise data warehousing?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
How to delete the (flat file) data in the target table after loaded.
how to get flatfile containg 10 records half records one target another half another target
Teradata 
