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
- 6592 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
What are the advantages of using informatica as an etl tool over teradata?
Mention few power centre client applications with their basic purpose?
What are the different components of powercenter?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
State the limitations where we cannot use joiner in the mapping pipeline?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Clarify the aggregator change?
What is a node in Informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How does the aggregator transformation handle null values?
How many ways are there to do 'remove duplicate records in informatica'?
what is the size of your data warehousing?
What is main use of mapplet?
Different sorts of metadata that stores in the storage facility?
what is the complex transformation you used in informatica
