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
- 6717 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
In how many ways we can create ports?
Please let me know how to make Data masking in informatica..
Explain informatica architecture - version 8 / 9
Separate from an archive server and a powerhouse?
tell me the rules and responsblites in our project(my project is development)
What are the different clients of powercenter?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain the different dimensions.
Explain dynamic target flat file name generation in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Partition, what happens if the specified key range is shorter and longer
in reporting we add some new objects,how we get the count of the newly added objects to the report
explain one complex mapping with logic? sales project?
Mention few advantages of router transformation over filter transformation.
