Answer / brahma

using set count varriable in expression transformation.

Answer / kalu bhai

without using sequence genarerater and lookup, we can
create sequence numbers in two ways 1.using of expresson
transformation 2. stored procedure transformation,

Answer / guest

Using oracle database sequence gen(from dual table)

Answer / sk

Using
1. SQL Trx
2. Exp

Answer / naveen

by using mapping variable we can also create a sequence number

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

What are the different tools in workflow manager?

1 Answers  

---

How to join three sources using joiner?

0 Answers  

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

---

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

---

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

---

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---