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 type of problem you faced insales project or insurance project

1 Answers   Sony,

what is song in infrmatica...?

0 Answers   CTS,

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 Answers  

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

what is degenerated dimension table with scenario

2 Answers   HCL,

can session assigned multiple mappings or not?

2 Answers   Zensar,

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

How can you differentiate between powercenter and power map?

0 Answers  

For more Informatica Interview Questions Click Here
Categories