I can't get something as simple as a lookup to work. When I try to debug to see what may be going on, the trace for the lookup does not display. It also shows 2 rows in 0s with 0 rows/s. What the hell do I make of that? Is there some trick or secret that I don't know that I need to use to get the trace for the lookup to display? Look at GroupLkp in my image.
Traces don't work on lookups. If you want to see what's coming from the lookup, I suggest you add a tLogRow into the flow.
If you explain exactly what's not working and screenprint the tMap settings (including schemas) someone might be able to help you determine the problem.
If traces don't work on lookups then the trace icon should not be there! Anyway, when I add a tLogRow into the flow, my lookup works. When I remove it, it stops working.
I've done some more testing with this and here is what is happening. When I remove the flow between a tMysqlInput and a tMap and recreate and RENAME that flow then run the job the key lookup will work (sort of*). As soon as I change anything in the tMap relating to that lookup it will no longer work.
*When the lookup does work it does a cartesian join.
I am using Data Integration v5.0.2r78327. I opened a ticket with support and I am awaiting a response. Images attached. I can't fit the entire tMap on my screen so I had to break it up into two images. EDIT: My images were too big. I'll email them to you. EDIT #2: The email form won't let me include attachments. I'll put the images on the web and provide links.
I can't get something as simple as a lookup to work. When I try to debug to see what may be going on, the trace for the lookup does not display. It also shows 2 rows in 0s with 0 rows/s. What the hell do I make of that? Is there some trick or secret that I don't know that I need to use to get the trace for the lookup to display? Look at GroupLkp in my image.
The data extract time is obviously less than the minimum value it can set. The number of records out is the same as the number in so either your joins are correct or you have the wrong rules set.
