my workflow is completed succesfully without any error .but SQ is not reading any data , so eventually no data is loaded in target.
my mapping is :
source(emp table)->SQ(emp table)->target(emp table)
data of emp table:
id sal name
1 1100 ummed
Note- I imported source and target structure from database(i.e connected successfully to database), and workflow also running properly so workflow connections are also correct.
If same query(as SQ) i run on DB then its showing this one row as output.
Please let me know what may be the problem.
Record is not getting rejected....I checked in workflow monitor- right click on session name-get run properties- in SQ tab rejected rows are 0....
even the data types are correct ..for number its Decimal in SQ and for varchar2 its string in SQ.
Try running the debugger and see what happens.Are the schema's are same.
Please check the source query generated in the session log and run that query in the SQL editor .
Let us know the results.
I dont think if he was diff. schema name then thier wud hv been any error..i encountered d same issue..but i do agree wid Sasi.. to run the debugger & see wat d issue is...i got mine solved aftr runnin d debugger..