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



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 achi..

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

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 achi..

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

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 achi..

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

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 achi..

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

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 achi..

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

Post New Answer

More Informatica Interview Questions

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,


Two different admin users created for repository are ______ and_______

1 Answers  


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.

3 Answers   Amdocs,


How can a transformation be made reusable?

0 Answers   Informatica,


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.

0 Answers   iGate,


Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,


Define Update Override?

1 Answers  


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?

3 Answers   TCS,


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.

2 Answers   Infosys, TCS,


what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,


wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,


Categories