Answer / krishna

Use database Sequence generator call this from stored
procedure or dummy lookup query

or

You can also use expression transformation. Create two
ports one is variable and assign it to 0 and another one is
output port ind Write the logic to increment it
(o_seq=v_Seq+1)

Answer / vijay

You can also use expression transformation. Write the logic
i = 0 and increment it in another column. Give this column
as output.

Answer / manikandan

I think your Express increment is not clear because when the second record will comes again it that variable is initialize to zero.

So we do to capture into Variable by SetVariable()

Or

The Use target lookup and return the column(SNo) which you what to populate the seq number.

Check in Express(before Target), If(isNull(SNo), 1, SNo+1). Connect this to SNo in Target

Answer / chaitanya

Use database Sequence generator

Answer / ganesh

You can handed this issue, using expression transformation.

1) create one variable port and declare it as Integer and
assign the value to Output port.

e.g: var_count Integer var_count+1
out_count Integer var_count

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  

---

what is size of u r database?

0 Answers  

---

without update strategy how to insert &update?

1 Answers   DELL,

---

How to generate sequence numbers?

0 Answers  

---

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

---

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

What is a pre-defined event and user-defined event?

0 Answers  

---

What is power center repository?

1 Answers  

---

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

---