The Definitive Guide to Data Quality
Selecting from the DUAL Table
DUAL is a table automatically created by Oracle Database along with the data dictionary. DUAL is in the schema of the user SYS but is accessible by the name DUAL to all users. It has one column, DUMMY, defined to be VARCHAR2(1), and contains one row with a value X. Selecting from the DUAL table is useful for computing a constant expression with the SELECT statement. Because DUAL has only one row, the constant is returned only once. Alternatively, you can select a constant, pseudocolumn, or expression from any table, but the value will be returned as many times as there are rows in the table. Please refer to "SQL Functions" for many examples of selecting a constant value from DUAL.
SELECT dummy FROM dual,
"select ' " + ((String)globalMap.get("Tns")) + " ' as outs from dual"
You need to show us the configuration of your tFlowToIterate component and your tOracleOutput3 (screenshots of how they are configured). I don't think you are assigning a value properly in the tFlowToIterate. It could also be that the value you are trying to assign is null. You can check this by placing a tLogRow in place of the tFlowToIterate as a test.
Please see screen shots ..
1. ) Job's flow
2. ) tFlowToIterate configuration
Your tFlowToIterate is iterating 407 times. This means your tOracleOutput3 is being fired 407 times.
If you give us some screenshots of your configuration (and prove that some value is being returned by the "assign_unmated_tns" component), we should be able to help.
I added one component assigned_unmatched_Tns before tFlowIterate. In this excel file , I got all 407 Tns. So flow is perfect before tFlowToIterate.
When you have more Talend experience this sort of problem will be easy to fix first hand. Unfortunately doing it remotely is a little tricky without being shown the detail we need.
I agree , I am struck before I don't have enough experience in Talend thats why I am having problems in fixing small issues too.
As Vapukov says, grab some sleep and post some screenshots for us to track down your issue in the morning.
Took good nap and ready to hit this job again . Thanks for your concern.
because it is - SELECT SINGLE_STATIC_TEXT FROM dual, because ((String)globalMap.get("Tns") - You are include in 'single quotes' making from them text
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema