How could we generate the sequence of key values without
using sequence generator transformation in the target ??

Answers were Sorted based on User's Feedback



How could we generate the sequence of key values without using sequence generator transformation i..

Answer / priyank

one varibale port.

Var_port=IIF(Var_port=0,1,Var_port+1)
Out_port=Var_port

Is This Answer Correct ?    0 Yes 2 No

How could we generate the sequence of key values without using sequence generator transformation i..

Answer / nagaraj

hi, kalyan
can u write that query in sql override.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

what is degenerated dimension?

1 Answers   IBM,


why do u use shortcuts in informatica.?

4 Answers   iFlex,


What are the different clients of powercenter?

0 Answers  


Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,


in performance wise union is past,union all is past

2 Answers  


Explain the difference between a data warehouse and a data mart?

0 Answers  


What is incremental aggregation?

0 Answers  


Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,


I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,


What is the difference between a repository server and a powerhouse?

0 Answers  


What are the tasks that source qualifier performs?

1 Answers  


Categories