u can use Sequence generator and Expression to A-->a,B-->bb,C-->ccc,D-->dddd,E-->eeeee Let's assume the input string is named VALUE and the total length is named TOTAL_LENGTH. Then you will need the following additional ports in the EXP: - One variable port v_length, type Integer, with this expression term: Length(VALUE) - One variable port v_pad_val, type String (250), with this expression term: LPAD( SUBSTR( VALUE, 1, 1), 250, SUBSTR( VALUE, 1, 1)) - One output port REPEATED_VALUE with this expression: SUBSTR( v_pad_val, 1, TOTAL_LENGTH)
Could it be that de seq transformation goes from 1 to 2? And then send to odd table those with 1 and to even table those with 2? Could this approach work for the next case where yo have 3, 4 or X number of target tables?
can u pls include a scenario for pyramid triangle data like A-->a,B-->bb,C-->ccc,D-->dddd,E-->eeeee pls explain the logic to execute this one .not by using normaliser pls
**Copied u can use Sequence generator and Expression to A-->a,B-->bb,C-->ccc,D-->dddd,E-->eeeee Let's assume the input string is named VALUE and the total length is named TOTAL_LENGTH. Then you will need the following additional ports in the EXP: - One variable port v_length, type Integer, with this expression term: Length(VALUE) - One variable port v_pad_val, type String (250), with this expression term: LPAD( SUBSTR( VALUE, 1, 1), 250, SUBSTR( VALUE, 1, 1)) - One output port REPEATED_VALUE with this expression: SUBSTR( v_pad_val, 1, TOTAL_LENGTH)
Why can't we just use cyclic seq generatr and route fields? Is my approach correct? Like for alternate we will use cyclic seq generatr with values 1,2 We will route the records with 1 into one target and 2 into another target..
u can use Sequence generator and Expression to A-->a,B-->bb,C-->ccc,D-->dddd,E-->eeeee
Let's assume the input string is named VALUE and the total length is named TOTAL_LENGTH.
Then you will need the following additional ports in the EXP:
- One variable port v_length, type Integer, with this expression term:
Length(VALUE)
- One variable port v_pad_val, type String (250), with this expression term:
LPAD( SUBSTR( VALUE, 1, 1), 250, SUBSTR( VALUE, 1, 1))
- One output port REPEATED_VALUE with this expression:
SUBSTR( v_pad_val, 1, TOTAL_LENGTH)
Could it be that de seq transformation goes from 1 to 2? And then send to odd table those with 1 and to even table those with 2?
Could this approach work for the next case where yo have 3, 4 or X number of target tables?
Hi
Without selecting the cycle checkbox and just giving the end value still the nextval gives alternate 1 and 2?
may i know what type of questions and at what depth questions will be asked for 12+ years experience
Hey , is there need for expression transformation after sequence generator in both scenarios?? Or is it just for understanding purpose?
Hello Sir, pls upload the video of indirect load methodology with more than 25 files, Thanks
can u pls include a scenario for pyramid triangle data like A-->a,B-->bb,C-->ccc,D-->dddd,E-->eeeee pls explain the logic to execute this one .not by using normaliser pls
**Copied
u can use Sequence generator and Expression to A-->a,B-->bb,C-->ccc,D-->dddd,E-->eeeee
Let's assume the input string is named VALUE and the total length is named TOTAL_LENGTH.
Then you will need the following additional ports in the EXP:
- One variable port v_length, type Integer, with this expression term:
Length(VALUE)
- One variable port v_pad_val, type String (250), with this expression term:
LPAD( SUBSTR( VALUE, 1, 1), 250, SUBSTR( VALUE, 1, 1))
- One output port REPEATED_VALUE with this expression:
SUBSTR( v_pad_val, 1, TOTAL_LENGTH)
Why can't we just use cyclic seq generatr and route fields?
Is my approach correct?
Like for alternate we will use cyclic seq generatr with values 1,2
We will route the records with 1 into one target and 2 into another target..
yes you can use..its also one of the ways