ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories >> Software >> Data-Warehouse >> Informatica
 
 
 
Question
S1 is having 1 lakh records and s2 is having 100 records, 
s2 should compare  s1 if emp no is same data should be 
updated if not their it should insert the data.what are the 
transformation used?
 Question Submitted By :: Lakshmi
I also faced this Question!!     Rank Answer Posted By  
 
Answer
In this scenario generally using the two transformations
(Joiner&UpdateStrategy Tx) if S1 and S2 are different 
sources or Flat files; 
  Else if both are in same sources as of relational then 
join it in SourceQulaifier Tx itself in this case no need 
for Joiner tx.

1) Joiner Tx will join the S1 and S2 by using common 
fields; here S2 is the Master table.

2)In UpdateStrategy Tx. Condition is like IIF
(s2.empno=s1.empno,1,0)
 
2
Madhava
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com