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 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target?

I am new to Informatica,can anybody suggest me the idea?

Question Posted / shiva55

Answers were Sorted based on User's Feedback



I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in..

Answer / sajid hussain

Step1: After SQ transformation take Sequence Generator transformation and edit properties like, Start Value=1, Increment By=1, End Value=3 and check the Cycle.

Step2: Now take a Router transformation and drag all the ports from SQ transformation to Router, as well as drag the NEXT VAL port from Sequence Generator transformation to Router.

Step3: Create 3 group T1, T2 and T3 and for each group condition will be like T1 --> NEXTVAL=1, T2 --> NEXTVAL=2 and T3 --> NEXTVAL=3

Step4: Connect all the 3 targets and run the mapping.

Is This Answer Correct ?    1 Yes 1 No

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in..

Answer / naveenkumar

drag and drop the source to the mapping and connect the expression transformation.variable port to an expression transformation
v_count=v_count+1
o_count=v_count
and exp transformation to connect the router transformation groups
column name<=25 lks
column name>=26 lks and column name<=50 lks
column name>=51 lks and column name<=75 lks
column name>=76 lks and column name <=1 cros

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

what is the incremental agrrigation?

2 Answers   Cap Gemini,

What is informatica? What exactly are the practical uses in real world

2 Answers  

What are the different clients of powercenter?

0 Answers  

explain different levels in pushdown optimization with example?

2 Answers   TCS,

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

Separate from an archive server and a powerhouse?

0 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

What is different between the data warehouse and data mart?

0 Answers  

what is the difference between repository & Intergration service

1 Answers  

What is blocking transformation?

0 Answers   Informatica,

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories