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

what is the predefined port in dynamic lookup

2 Answers  


Implementation methodology

0 Answers  


Explain the difference between mapping parameter and mapping variable?

0 Answers  


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


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?

1 Answers   TCS,


I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,


h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,


hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,


Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,


my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,


Why filter transformation is an active one?

0 Answers  


Categories