Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 9246 Views
- iNautix, I also Faced
- E-Mail Answers
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
What is deployment group?
Explain what are the different types of transformation available in informatica.
How to create Target definition for flat files?
How can we create index after completion of load process?
Global and Local shortcuts. Advantages.
Where are the source flat files kept before running the session?
What are the performance considerations when working with aggregator transformation?
can u any challenge your project?
How to extract sap data using informatica?
how to create user defined function (udf) in informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
What will be the approach?
What is Data Caches size?
Define joiner transformation?
Explain the features of connected and unconnected lookup.
