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

if we have certain records,if i need to get 5 th rec for the
first time to the target,when i run it for next time,i need
to get 6th rec...like that it should process.what wil be the
procedure to achieve it??

Question Posted / prasu


if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it..

Answer / zer0

I guess this should work ........

Source --> SQ --> Exp --> Filter --> Exp --> Target
|
|
SG

Firstly create a mapping variable say $$count and give it
the default value 5.
Create a port in Expression say Srno. and connect the
sequence generator to it (so that it will mark the rownums).
Then in Filter place the condition Srno = $$count
In the second Expression create an extra port and give it
the value SETCOUNTVARIABLE($$count) (this will increment
the mapping variable).
Next time the job runs it will take value of $$count as 6
and so on ........

Kindly revert if this worked ........

Is This Answer Correct ?    20 Yes 1 No

Post New Answer

More Informatica Interview Questions

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

What is data transformation manager process?

0 Answers  

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

how i will stop my workflow after 10 errors

2 Answers   HP,

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

Write the advantages of partitioning a session?

0 Answers  

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories