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'

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1730

---

What is sorter transformation?

991

---

What is event and what are the tasks related to it?

1069

---

What are the differences between a connected lookup and unconnected lookup?

1027

---

what is SDLC way of code development?

1981

---

Explain how many types of dimensions are available in informatica?

1023

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2012

---

State the differences between sql override and lookup override?

1125

---

What is rank transformation in informatica

1120

---

How can we use batches?

976

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1234

---

can we override a native sql query within informatica? Where do we do it?

1080

---

How is union transformation utilized?

959

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1983

---

What is the status code in stored procedure transformation?

1131

---