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 find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7177

---

Explain dynamic target flat file name generation in informatica

1109

---

What are the types of lookup transformation?

1119

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7498

---

define galaxy repository in informatica

2285

---

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

7671

---

What is a node in Informatica?

1085

---

What are roles and groups and benefits of using them?

1103

---

How can repository reports be accessed without sql or other transformations?

1268

---

What is the different lookup cache(s)?

1129

---

Can you generate sequence numbers without using the sequence generator transformation?

1162

---

What are the limitations of joiner transformation?

1176

---

What is a router transformation?

1212

---

what is the complex transformation you used in informatica

2623

---

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

1286

---