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
Repository user profiles
What are the different options available for update strategy?
How do you convert single row from source into three rows into target?
Differentiate between joiner and lookup transformation?
What is a sorter transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain in detail about scd type 1 through mapping.
Enlist the various types of transformations.
What are the differences between joiner transformation and source qualifier transformation?
What is the difference between router and filter?
What is a joiner transformation and why it is an active one?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What the difference is between a database, a data warehouse and a data mart?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?