Interested to Buy Any Domain ? << Click Here >> for more details...
my source having the records like
ram 3
sam 5
tom 8
and i want to load into target like ram record 3 times,sam
record 5 times, tom record 8 times
- 3 Answers
- 7252 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
let us take the metadata as name and records ok,
in expression t/r we create a new o/p port in that write the
expression as name ||''||record||''||records||''|| times
connect the newly created o/p port to the target.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / prasad
In that case we use Normalizer transformation.
SQ--->Expression----->Normalizer----->TGT
1.Drag the ports from SQ to Expression TX.
2.In Normalizer TX we can assign the occurrences as
for ramu record define the occurrences as 3
for sam record define the occurrences as 5
for tom record define the occurrences as 8
It makes to split the record in to the desired no of times..
Hope it will work.
Please correct me if any mistakes in my answer...
| Is This Answer Correct ? | 1 Yes | 5 No |
How to load only the first and last record of a flat file into the target?
why we use materialized view over view?
What are the scheduling options to run a sesion?
How might you approve all mappings in the archive all the while?
What is meant by incremental aggregation?
how we can do session partition in informatica any one explain me clearly? thanks advance.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How to join three sources using joiner? Explain though mapping flow.
Where do you create/define mapping parameter and mapping variable?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How will you update the first four rows and insert next four rows in a mapping?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Teradata 
