Answer Posted / balakrushna

Hi Mukunda,
U r correct but, y u are using addional t/r Exp, without
EXP we will make this mapping scenario,

I made it actually, that is the way i am sending this
like as follow

SQ-Gen-|
|
Source--> SQL------>RTR->Target1
|
|--->Target2

In SQ-Gen:
Change the Startvalue, Endvalue and Check the CYCLE and
RESET option in the properties of SQ-Gen
popuklate the NEXTVAL from Seq_gen to RTR.

In the RTR t/r:
(as my scnario the 3 records will load tgt1 and next 3 will
load in tgt2 and next 3 will load in again TGT1 and so on..)
2 groups
one is NEXTVAL <= 3
and NEXTVAL >= 4
and populated these groups to ur target accordingly.

Thanks & Regards
Balakrushna

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2187

---

How can we use mapping variables in informatica? Where do we use them?

1286

---

differences between service based and product based?

2060

---

What is resilience time?

1227

---

pmscmd startworkflow -sv -d -u -p -f 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?

1557

---

How is union transformation utilized?

1060

---

What are active and passive transformations?

1132

---

What are the mapping parameters and mapping variables?

1272

---

Which is the t/r that builts only single cache memory?

1238

---

Explain the different kinds of facts.

1020

---

How an expression transformation differs from aggregator transformation?

1087

---

What is the maplet?

1203

---

Briefly define a session task?

1195

---

how we can load rejected record's at run time?(not through bad files)

2427

---

What is complex mapping?

1171

---