Answer Posted / srinu

Mainly sequence generator is used to generate an unique id
dynamically.
We can not join this number against any column in other
tables...
So.. we can not connect sequence generator with joiner.

and also,

Main reason is joiner is a Active transformation.Means it
can alter the number of rows.
So, if u connect sequence generator with joiner the outcome
sequence will not be proper.

Any Queries or Corrections
'srinu.srinuvas@gmail.com'

what is $$$$?

2095

---

What are the differences between oltp and olap?

920

---

What are the uses of etl tools?

1064

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2506

---

is it possible to index the data in cache of lkp transformation ?

1958

---

What are multi-group transformations?

1010

---

What is standalone command task?

1256

---

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?

998

---

What are the types of schemas we have in data warehouse and what are the difference between them?

887

---

What is powercenter on grid?

1125

---

What are the types of presistent cache in look up tr.

2004

---

what is mean by complex business rule ?

2108

---

How to do unit testing in informatica? How to load data in informatica ?

1045

---

Separate from an archive server and a powerhouse?

904

---

Different circumstance which drives informatica server to expel records?

913

---