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
- 6799 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
explain one complex mapping with logic? sales project?
What are the different transaction levels available in transaction control transformation?
What is the difference between informatics 7x and 8x and what is latest version?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Difference between Target-based loading and constraint-based loading?
In development project what is the process to follow for an etl developer from day1
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the popular informatica products?
How to implement security measures using repository manager?
What are the performance considerations when working with aggregator transformation?
What is substr in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Is it possible to define a single node as a Gateway node as well as worker node?
What is informatica? Why do we need it?
