database - Is self join possible in lookup Transformation? If yes how do we get managers for all the employees using Lookup transformation -

-

is self join possible in lookup transformation, if yes how managers employees using lookup transformation?

yes kinds of joins possible in lookup transformation using sql override. write sql return employee , manager ids. can put employee id in conditions tab , use manager id output or return port.


Comments

Post a Comment

Popular posts from this blog

python - No exponential form of the z-axis in matplotlib-3D-plots -

-
Image
i have similar problem described in how prevent numbers being changed exponential form in python matplotlib figure : i don't want (in special case) weird scientific formatting of axis. problem different have problem @ z -axis. 2-d plots can use ax.get_yaxis().get_major_formatter().set_useoffset(false) . , there no function ax.get_zaxis() what use format z -axis same way? edit: example: from mpl_toolkits.mplot3d import axes3d import numpy np import sys import matplotlib import matplotlib.pyplot pyplot def func(xi, ti): res = 10e3 + np.cos(ti) * np.sin(xi) return res if __name__ == '__main__': timespacing = 20 timestart = 0 timeend = 1 time = np.linspace(timestart, timeend, timespacing) widthspacing = 50 widthstart = 0 widthend = 3 width = np.linspace(widthstart, widthend, widthspacing) reslist = [] matplotlib.rcparams['legend.fontsize'] = 10 fig = pyplot.figure() ax = fig.gca(projection = '3d...
Read more

python - PIL cannot identify image file for io.BytesIO object -

-
i using pillow fork of pil , keep receiving error oserror: cannot identify image file <_io.bytesio object @ 0x103a47468> when trying open image. using virtualenv python 3.4 , no installation of pil. i have tried find solution based on others encountering same problem, however, solutions did not work me. here code: from pil import image import io # portion part of test code byteimg = image.open("some/location/to/a/file/in/my/directories.png").tobytes() # non test code databytesio = io.bytesio(byteimg) image.open(databytesio) # <- error here the image exists in initial opening of file , gets converted bytes. appears work else can't figure out why fails me. edit: databytesio.seek(0) does not work solution (tried it) since i'm not saving image via stream, i'm instantiating bytesio data, therefore (if i'm thinking of correctly) seek should @ 0. (this solution author himself. have moved here.) solution: # portion part ...
Read more

portaudio - How to enable WASAPI exclusive mode in pyaudio -

-
i'm using these precompiled binaries of pyaudio wasapi support. want play wav file via wasapi. found index of default output device api: import pyaudio p = pyaudio.pyaudio() print p.get_host_api_info_by_index(3) >>{'index': 3, 'name': u'windows wasapi', 'defaultoutputdevice': 11l, 'type': 13l, 'devicecount': 3l, 'defaultinputdevice': 12l, 'structversion': 1l} then play wav file via device: import pyaudio import wave chunk = 1024 wf = wave.open('test.wav', 'rb') # instantiate pyaudio (1) p = pyaudio.pyaudio() # open stream (2) stream = p.open(format=p.get_format_from_width(wf.getsampwidth()), channels=wf.getnchannels(), rate=wf.getframerate(), output_device_index=11, output=true) # read data data = wf.readframes(chunk) # play stream (3) while data != '': stream.write(data) data = wf.readframes(chunk) ...
Read more