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
- 9405 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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Which files are created during the session rums by informatics server?
What is sq transformation?
What is persistent lookup cache?
What are the different components of powercenter?
Can we create a Integration service without a Repository service and vice versa?
How can we improve session performance in aggregator transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Design a mapping to load a target table with the following values from the above source?
What is meant by lookup transformation? Explain the types of lookup transformation?
Differentiate between source qualifier and filter transformation?
What is union transformation?
Explain target update override in informatica
Explain sessions. Explain how batches are used to combine executions?
What differs when we choose the sorted input for aggregator transformation?
