Answer Posted / babu

Hi,

mapping:
Src==>SQ==>Exp(Nextval,Src_column)==>Rtr(3 Groups)==>T1,T2,T2
||
Seq


the above dagram represents the data flow from source to targets


Seq:Sequence generator from generate the sequence
numbers(1,2,3)only Max Val=3,please enable cycle option.

Rtr:Router transformation have 3 groups,Grp1,Grp2,Grp3
Grp1=1 ==>T1
Grp2=2 ==>T2
Grp3=3 ==>T3

please let me know if any thing wrong.

How to use pmcmd utility command?

964

---

How can one identify whether mapping is correct or not without connecting session?

1368

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1112

---

What are the advantages of using informatica as an etl tool over teradata?

969

---

How can we create index after completion of load process?

1071

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1585

---

what is the complex transformation you used in informatica

2524

---

Define Pmrep command?

996

---

Is stop and abort are same in informatica?

947

---

what is diff b/t sorter t/r and agg have the option sorter property...

2129

---

What is the function of look up transformation?

1054

---

What does role playing dimension mean?

997

---

What is an expression transformation in informatica?

963

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1574

---

Can informatica load heterogeneous targets from heterogeneous sources?

1118

---