Answer Posted / ganesh kamble

We can clearly understand that we need a Router transformation to route or filter source data to the three target tables. Now the question is what will be the filter conditions.

First of all we need an Expression Transformation where we have all the source table columns and along with that we have another i/o port say seq_num, which gets sequence numbers for each source row from the port NEXTVAL of a Sequence Generator start value 0 and increment by 1.

Now the filter condition for the three router groups will be:
MOD(SEQ_NUM,3)=1 connected to 1st target table MOD(SEQ_NUM,3)=2 connected to 2nd target table MOD(SEQ_NUM,3)=0 connected to 3rd target table

How can we use mapping variables in informatica?

1036

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6440

---

According to his methodology what all you need before you build a datawarehouse

1738

---

How to implement security measures using repository manager?

1143

---

What is a dimensional model?

962

---

Different circumstance which drives informatica server to expel records?

959

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1057

---

What are the types of data warehouses?

1496

---

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

1008

---

What are the new features of Power Center 5.0?

1752

---

wf dont have integration severances how you can run?

1920

---

What is primary and backup node?

1110

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1151

---

define galaxy repository in informatica

2204

---

How to create the source and target database connections in server manager?

1071

---