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 |
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
Why we use ENABLE HIGH PRECISION in session properties?
Two different admin users created for repository are ______ and_______
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
How can a transformation be made reusable?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
Define Update Override?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
what is the mechanism of the Master-Detail joining condition?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.