Answer Posted / santosh kumar sarangi

1.first sort the data with sorter t/r as ID key column and
create below port in exp transformation
var2= var1
id
var1=id
rec_count=iff(var1=var2,rec_count+1,1)
2.Give all the port to router t/r and give the filer
condition as below
rec_count=1 then to first target
default to 2nd target

Let me know if any things is wrong.

Thanks & Regards
Santosh Kumar Sarangi

What is the use of code page?

1096

---

What are the differences between joiner transformation and source qualifier transformation?

1172

---

what is the hint? how to use it to reduce the query processing in program?

7838

---

Explain load alternative records / rows into multiple targets - informatica

1153

---

What is the reusable transformation?

1047

---

In which transformation you cannot drag ports into it?

1320

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1963

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1975

---

How identifying bottlenecks in various components of informatica and resolving them?

1133

---

What is a difference between complete, stop and abort?

1083

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1109

---

What is primary and backup node?

1128

---

What is the need for an etl tool?

1068

---

what is unit testing?tell me proceedure

2223

---

What is informatica?

1156

---