Answer Posted / mukunda

we have to follow the follwing pipe line

seq--|
SOURCE-->SQ-->EXP-->STOREPROCEDURE-->EXP--->ROUTER---->T1
|------>T2

Using store procedure we can count the total no of rows.
Using sequence genater we have to create the assign the
value to each row. Then find the max rowid using the srore
Procedure t/r. Then this result value store as 'n'. And
the wrire the conditon in router tranformation.
GROUP1--->N<=N/2--->connected to Target1
GROUP2--->N>=N+1/2--->Connected to Target2

*FOR exaple the source table is containg 99 records.
Using the store procedure we can find the count value n as
99.
Conditoin1-->N<=N/2(=44)44 records store in to target1.
Condition2--->N>=N+1/2(=45)-->45 Records store in to the
target2.


If you have any quires plese ask. mukunda.velluri@gmail.com

I have a flat file, want to reverse the contents of the flat file

1172

---

Explain how many types of dimensions are available in informatica?

1173

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2073

---

what is the difference between informatica6.1 and infomatica7.1

2362

---

How can a transformation be made reusable?

1239

---

What is the cumulative sum and moving sum?

1236

---

How to elaborate tracing level?

1219

---

What is a shortcut and copy in Informatica and how two are different with each other?

1242

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2410

---

What is status code in informatica?

1065

---

Under what condition selecting sorted input in aggregator may fail the session?

1175

---

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

1292

---

How to go to the older version for a mapping?

1159

---

Difference between Target-based loading and constraint-based loading?

1042

---

How many number of sessions can one group in batches?

1216

---