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
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 DELETE A RECORD FROM FLAT FILE
Why we use partitioning the session in informatica?
How i can upload the MainFrame source For Informatica ?
How to create Target definition for flat files?
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
how to work with mapplet designer in informatica?
Diffrence between 7.1,8.1 and 8.6
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks