Hi, Im new to Talend, but old to Microsoft SSIS is there any component that resembles conditional split in SSIS. i searched a lot but didnt find one. The Scenario is this i have a single input task and 2 scd, one SCD does SCD type 1 and Other does SCD type 2 i need to control the flow of the input data with a variable. if the variable is 1 then it has to do only the SCD 1 operation and 2 vice versa. i too tried something no result, i also attached some images with this, Please have a look.
Hi, If you have a variable for 1 and 2 in input data, then there is no need of tMap. Use tFilterrow and filter and reject record based on the value of variable. Connect scd1 and scd2...? Using tmap also is simple to implement... filter data at the output for your variable 1 and 2, so flow will be allowed in respective output for scd1 or scd2 when input has 1 or 2 respectively. But doubt is how you can have value of 1 and 2 in variable???? Vaibhav
The scenario is simple, i would like to have 2 scd component one for scd1 and another for scd2 by default it may be scd 1 loading strategy but if in future if i need to enable scd 2 i just need to change the variabe to 2. that all
Consider that i have a table with two field column 1 as job name and column 2 as scd strategy field the thing i have entry of all the name of the job and how the loading should be done in this table Now how do i fetch the corresponding value from that table to a variable for running that tmap as we discussed above
Use a query "select * from yourtablename where column_1 = 'jobName'". Here jobName is talend system variable. From this you will get column2 as scd strategy. Assign its value to context variable and then execute actual job. If your job names are not standardized as per talend job name then you will have to modify query accordingly so as to identify relevant job. Vaibhav