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

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

Question Posted / harish konda

Answer Posted / harish konda

1. Declare workflow and mapping variables and assign them in Pre and Post session.

2. Use Transaction control transformation to create the target files dynamically.

Like everytime you run the session you can create the target file with the value of mapping variable as a run number.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Performance tuning( what you did in performance tuning)

1987

What is a surrogate key?

1081

What is the status code in stored procedure transformation?

1182

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091

whats the logic to load the lower level of granularity of data to fact table.

2276

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1777

What is olap (on-line analytical processing?

1069

How to call shell scripts from informatica?

997

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6179

How will the document be delivered to me?

1085

can you please explain me pre session and post session options?

7566

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

1632

Define filter transformation?

1097

Explain the different dimensions.

965

What are the restrictions of union transformation?

1041