Answer / 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'

how to get the first row without using rank t/r?

7 Answers   iGate,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

What are the data movement modes in informatcia?

3 Answers  

---

what is metadata?

6 Answers  

---

What is decode in static cache?

0 Answers  

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,

---

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

0 Answers  

---

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

---

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

---

What is repository manager?

0 Answers  

---