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 to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

Question Posted / srinivasan.palle

Answers were Sorted based on User's Feedback



how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to t..

Answer / dilip ingole

BY USING SQL

WITH DATA AS(SELECT NUM,ROWNUM RN ,COUNT(1)OVER() CNT FROM A)
SELECT NUM,RN FROM DATA WHERE RN=1
UNION
SELECT NUM,RN FROM DATA WHERE RN=CNT;

Is This Answer Correct ?    0 Yes 0 No

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to t..

Answer / triveni

source->sq->sequencegenerato->expression->filter->target
nextval to expressiontransformation
seq(output) decimal 10 nextval
startval=1,endvalue=14,cycle
mapping variable:$$var varible integer 10 o max
intialvalue=0
filter decimal 10
setvariable( $$seq,($$seq+1))

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

What are the differences between source qualifier and joiner transformation?

0 Answers  

What are the scheduling options to run a sesion?

2 Answers  

what is plsql table?

2 Answers  

In Which scenario did u used Incremental loading?

2 Answers  

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

How the Informatica Server reads perameter file?

1 Answers  

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

For more Informatica Interview Questions Click Here
Categories