Answer / informatica

use a sorter and do a descending sort. calculate the row_id.
pass it to a router. 1 group condition will be row_id=1.
2nd group row_id >1.1st group to one target instance. 2nd
group to another target instance.

Answer / swarup

sorter(key=requiredkey)
expression
router=1stgrp(o_cnt=1),2nd grp(o_cnt>=1)

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

---

How many repositories can be created in informatica?

1 Answers  

---

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

---

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

---

what is casual dimension?

6 Answers   IBM,

---

What is the difference between Normal load and Bulk load?

5 Answers  

---

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

---

Define the various join types of joiner transformation?

0 Answers  

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

---