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'

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

---

what is parallel querying and what r hints.

1 Answers  

---

how can i invoke pmcmd in command line prompt

1 Answers  

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,

---

What are Business Components in Informatica?

1 Answers  

---

why we use materialized view over view?

1 Answers   Zensar,

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---