Answer / venkatesh.malneni

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.

Answer / james

Hi Guys,

we can get the desired result set using Java t/r applying
for loop.

Please let me know if you have any suggestions.

Thanks,
James.

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...

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  

---

What are the performance considerations when working with aggregator transformation?

0 Answers  

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

---

---

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

---

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

---

How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  

---

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

---

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,

---