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
Whats the difference between informatica powercenter server, repositoryserver and repository?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is rank index in rank transformation?
How do you handle two sessions in Informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain pmcmd command usage in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the different versions of informatica?
What are the static cache and dynamic cache in informatica?
What is workflow? What are the components of the workflow manager?
Explain how many types of dimensions are available in informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
generate date / time dimension in informatica