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
- 6273 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Difference between Data and Index Caches?
what is the complex transformation you used in informatica
EXL informatica Questions
Tell me about Propagate functions in informatica
How can we use mapping variables in informatica? Where do we use them?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
design of staging area?
What is InformaticaPowerCenter?
What is an expression transformation in informatica?
What is the scenario which compels informatica server to reject files?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What are connected or unconnected transformations?
What is informatica etl tool?
What are the restrictions of union transformation?
Explain your project of banking domian.
