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

in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?

2 Answers   Thomson Reuters,

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,

What is the difference between router and filter?

0 Answers  

What are multi-group transformations?

0 Answers   Informatica,

What are the new features of informatica 9.x in developer level?

0 Answers  

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

0 Answers   Informatica,

What is a filter transformation?

0 Answers  

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

2 Answers  

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

Why use shortcuts(Instead of making copies).

1 Answers  

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,