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 can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).


Question Posted / chaitanya

Answer Posted / chaitanya

Use database Sequence generator

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is domain in terms of informatica?

952

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1048

What is domain and gateway node?

1119

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1194

What are the mapping parameters and mapping variables?

1087

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1574

Enlist the various types of transformations.

952

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1604

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5561

Can you generate sequence numbers without using the sequence generator transformation?

1049

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1841

Explain why we use partitioning the session in informatica?

1005

Which transformation should we use to normalise the COBOL and relational sources?

1141

Can we create multiple integration service on single repository?

1132

How do you manage the Parameter files while migrating your data from one environment to another environment?

963