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

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,


difference between repository database and repository service?

0 Answers  


Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,


I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  


Which kind of index is preferred in DWH?

2 Answers  


Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,


Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,


How to extract original records at one target & Duplicate records at one target?

12 Answers  


if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,


what is confirmed dimension?

6 Answers  


How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,


what is the significance of newlookup port in dynamic look up

1 Answers   IBM,


Categories