Answer / srikanth

try below mapping in mapping designer

source->sourcequalifier->exptf1->trg( for n records)
->exptf2(with
sequencegtf)->routertf(sequence column=1 AND
5)->trginstance(same above trg)

Finally you will get total n+5 records into target. Here i
used only one target. just i taken instance.

It will work..

What are the different types of Type2 dimension maping?

1 Answers  

---

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

---

What is synonym?

2 Answers   Patni,

---

How many ways are there to create ports?

0 Answers   Informatica,

---

How to extract sap data using informatica?

0 Answers  

---

---

What is the capacity of power cube?

1 Answers  

---

Define error Threshold?

1 Answers  

---

Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

---

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,

---