Conditional check with variable

[Anonymous]

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.

Thank you

[Anonymous]

What is the datatype of context.scd and what is default value?
Vaibhav

[Anonymous]

Integer.

[Anonymous]

and what is default value inside context editor window?

[Anonymous]

Thanks sanvaibhav.,
Found whats the mistake its the "Default" in value as tree, i created a new context in it thats y the job runs and data isnt flowing. now i changed the default value and it runs.

Thanks a Lot

[Anonymous]

and if u dont mind can i continue with one more doubt

[Anonymous]

If it is related to same topic, then pl continue... else mark this topic as fixed and open new one.
Vaibhav

[Anonymous]

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

[Anonymous]

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