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

[willm1]

maharaj.narayanan - can you show us a screenshot of your tMap mapping?

[Anonymous]

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

[Anonymous]

Im not sure with this

[Anonymous]

I think you need to revisit the business logic and come up with some logical scenario for the business problem.
Vaibhav

[Anonymous]

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

[Anonymous]

Solution is also very simple.
- Create a context variable context.select_scd as integer. Set its value to 1
- Use filter condition in tmap for 1 or 2 as per the screenshot
Thanks
Vaibhav

[Anonymous]

hi sanvaibhav,
Thanks a lot for the reply but this is what i too did but no data flows either way.
thats y i posted this question.
thankyou

[Anonymous]

Can you put the screenshot of your tmap.
I created a small poc to show it works. See two screenshots alternate when the value is swapped from 1 to 2
Vaibhav

[Anonymous]

this is my tmap
http://postimg.org/image/jea7vi55h/