In Flat file
Input is
A
B
C
I need output like this
A
A
A
B
B
B
C
C
C. How will u achieve this?
Answers were Sorted based on User's Feedback
Answer / abhinaw prakash
We can use normalizer for this.
send the ports from SQ to Normalizer.
In Normalizer put the occurrence of the incoming column as 3.
Connect the only column from SQ to the 3 incoming port in
Normalizer.
Connect the O/P column from Normalizer to target.
Is This Answer Correct ? | 20 Yes | 0 No |
Answer / moorthy, g
Hi All,
SRC-SQ-JAVA-TGT
In Java Transformation:
on Input row:
you have to add
for(int i=0;i<3;i++)
{
IN_NAME=OUT_NAME;
generateRow();
}
this is the simple way... we can do this.
Best Regards,
Moorthy. G
http://manthiramoorthy.blogspot.in/
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / jyothi
source s1
take 3 instance of Target(
t1
/
/
s1---exp----t2
\
\
t3
load data we will get record as mentioned in output
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / ankur saini
to make this simple from sq--take 3 expressions---add union
to take data from theses three expressions
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / jyothi
source s1 contains input data (A B C)
take 3 flows in mapping
create 3 instances for the target.
ex: target is T .Instances for T are t1 t2 t3
t1
/
/
s1---exp---t2
\
\
t3
load the data into targets using target load strategy
then we will get output as above
Is This Answer Correct ? | 0 Yes | 3 No |
scenario
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
hw cn v elimate dublicate values from lookup without overriding sql?
What is workflow monitor?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
what are the limitations of pushdown optimization technique ? Advance thanks
What is Datadriven?
what are surrogate keys?
Can we insert ,update ,delete in target tables with one update strategy tran.?
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,