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 / kuni_ankita


i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,..

Answer / 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

More Informatica Interview Questions

can we create index and drop index in exsisting table while using infomatica

4 Answers  

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

how i will stop my workflow after 10 errors

1 Answers   HP,

What is workflow? What are the components of workflow manager?

0 Answers  

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

What is rank index in rank transformation?

0 Answers  

Differentiate between a database and data warehouse?

0 Answers  

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

what type of transformation is not supported by mapplets?

4 Answers   CTS,

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

checkout and checkin in informatica 8.6

3 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories