Using User_defined SQL Query file in DRs Stage

[tulasi]

hi,

i am facing problem when trying to place the user defined sql query to the DRS Stage in our job. As the query is too long and complex, i am unable to place the whole query in a single DRS stage.so, thought of Using User_defined SQL Query file option in DRS stage.
Could please help me on using this option clerly like where the file path and name to be placed in DRS stage.
Thanks in Advance
Tulasi.

[chulett]

Set the query type to 'User-defined SQL query file' and then put the full path to the file where the sql itself would normally be.

[chulett]

If that doesn't help, consider having a View created that implements your too long and complex join. That way it's just a simple select to implement.