GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica

 Print  |  
Question:  Sequence Generator

Answer: Why sequence generator is not directly connected to joiner transformation?


September 09, 2009 15:08:28 #5
 manoj_pathak   Member Since: September 2009    Total Comments: 2 

RE: Sequence Generator
 
Remember Joiner tx can accept input from only 2 pipelines.

Now only following 2 scenerios possible to have both joiner and Seq Gen tx:
1)2 input pipelines are already connected and then we want to connect Seq Gen to joiner: In this scenerio, the input from Seq Gen will be a input from third pipeline thus, informatica will thro error on that.

2)Only 1 input pipeleine is connected and we want to connect Seq Gen: In this case, ifnromatica will allow you to connect the Seq Gen but then u wont have the mathing CONDITION. thus, this scenerio is practically impossible.

So, both the above scenerios of having Seq Gen with Joiner arent PRACTICALLY possible.

Thanks,
Manoj
     

 

Back To Question