Answer Posted / mithilesh kumar rai

step 1. Pass the value from Source Qualifier to Expression.
step 2. Take a Sequence Generator and Enable the Option
Reset and set endvalue=3 , (take Sequence generator
before expression and pass value nextval of SG to Exp.

step3. after Exp, take router in router make 3 group
1st Group: Nextval=1
2nd Group: Nextval=2
3rd Group: Nextval=3
Step 4: Pass the value to Target.

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1007

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1976

---

How can you generate reports in informatica?

973

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

7880

---

What is a transaction control transformation?

1145

---

what is the complex transformation you used in informatica

2527

---

What is the session task and command task?

994

---

How to generate sequence numbers using expression transformation?

1029

---

Repository user profiles

1714

---

What is data caches/ index caches?

1024

---

Differentiate between reusable transformation and mapplet.

1030

---

What are the reusable transformations?

1099

---

What the difference is between a database, a data warehouse and a data mart?

1082

---

Define mapplet?

964

---

What are the various types of transformation?

1096

---