How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / g. manthiramoorthy
Create Two Port in Exp. Trans
v_temp : v_temp+1
o_seq : IIF(ISNULL(v_temp),0,v_temp)
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the difference between router and filter?
What is flashback table ? Advance thanks
What are the tasks that can be performed using sq?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How do you load only null records into target?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are connected or unconnected transformations?
Explain transaction control transformation in informatica
What are the static cache and dynamic cache in informatica?
What is the status code in stored procedure transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the main issues while working with flat files as source and as targets ?
What is blocking transformation?
Under what condition selecting sorted input in aggregator may fail the session?