1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / purva

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

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

Where do you create/define mapping parameter and mapping variable?

1 Answers  




what is metadata?

8 Answers   Satyam,

what are presession,postsession success and postsession failure commands ?

1 Answers  

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

Global and Local shortcuts. Advantages.

0 Answers  

For more Informatica Interview Questions Click Here
Categories