Deepak Rajkumar

 Profile Answers by Deepak Rajkumar 

• Feb 18th, 2008

 

Not sure about session stops without loading. We can join flat files without matching coloumns by:1: use a Seq. Gen. and generate Pks and join using Joiner.

Sreeya

 Profile Answers by Sreeya 

• Feb 21st, 2008

 

For the 1st part, we can adopt the recovery options as given in the session property, using the recovery strategy.But using this in real time scenario has proved to take a toll on the performance.Another approach can be to build a logic in the mapping which takes care of it.this can be done using variables.

For the 2nd part, we can introduce dummy ports with the same value in both the flat files and then can join on that port.

Thanks