If u had to split the source level key going into two seperate tables. One as surrogate and other as primary. Since informatica does not gurantee keys are loaded properly(order!) into those tables. What are the different ways you could handle this type of situation?

  • Interview Candidate
  • 3
  • 2180

Showing Answers 1 - 3 of 3 Answers

kareem

  • Mar 17th, 2006
 

foreign key

  Was this answer useful?  Yes

Dharma

  • Sep 20th, 2006
 

Plz explain me briefly regarding ths.Thank U

  Was this answer useful?  Yes

sreedhar

  • Sep 27th, 2006
 

 u r sending data into two different tbls ... of course by setting primary key in the target tables ..the thing is  the surrogate key generation requires seperate mapping which suits for scd concept..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions