Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

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

5 Answers   Cegedim,

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

What are the types of presistent cache in look up tr.

0 Answers   IBM,

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

What is pmcmd command?

0 Answers  

What is dimensional table?

0 Answers  

For more Informatica Interview Questions Click Here
Categories