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 / 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 |
Post New Answer View All Answers
Enlist the various types of transformations.
Explain why we use partitioning the session in informatica?
What are the data movement modes in informatica?
To import the flat file definition into the designer where should the flat file be placed?
What are pre and post-session shell commands?
what is song in infrmatica...?
Can we override a native sql query within informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the measure objects?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Performance tuning( what you did in performance tuning)
Tell me about MD5 functions in informatica
What is rank index in rank transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project