In Flat file Input is A B C I need output like this A A A B B B C C

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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?

Question Posted / jeyakumar.uv

5 Answers
9411 Views
iNautix, I also Faced
E-Mail Answers

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