without using joiner transformation n sql override how can we join two tables
hi,
how can i join two tables (from same schema) without using joiner transformation and without using SQL override.
i tried using source qualifier transformation, but at one point i m gettin strucked that how will i join data from these table without using joining condition i.e without writing sql overridee.
Please help.
Re: without using joiner transformation n sql override how can we join two tables
hi,
why dnt you try with lookup override in lookup t/f.
this will work.
reply me back if doesn't workout this
[QUOTE=neelkamal88;11974]hi,
how can i join two tables (from same schema) without using joiner transformation and without using SQL override.
i tried using source qualifier transformation, but at one point i m gettin strucked that how will i join data from these table without using joining condition i.e without writing sql overridee.
Please help.[/QUOTE]