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 |
What are connected or unconnected transformations?
What are the components of Informatica? And what is the purpose of each?
What is log file,and where is it located,why u r using the log file
How to recover sessions in concurrent batches?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
How can we store previous session logs?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
How does the session recovery work.
SO many times i saw "$PM parser error " .what is meant by PM?
i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence