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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to go to the older version for a mapping?

606


What are the reusable transformations?

704


What are the transformations that are not supported in mapplet?

604


Mention few power centre client applications with their basic purpose?

540


What is xml source qualifier transformation in informatica?

718






What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1641


How can you validate all mappings in the repository simultaneously?

762


What is repository manager?

538


Explain why we use partitioning the session in informatica?

617


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1735


have u done any performance tuning? how u ll do?

1863


How does a sorter cache works?

573


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

630


Define enterprise data warehousing?

637


what is size of u r database?

1852