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

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

Question Posted / babu

Answer Posted / babu

Hi,
If u r source is Relational,then u can write sqloverride.
i.e
SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> (num >= MVar1 and num <=MVar2)

NOTE: MVar1,MVar2 are mapping variables the initial values
of these variables 1,10 with respectivelly.

after completion of firsst run the variables are increased
11,20 respectivelly.all are knows how to declare the
mapping variables.
IF THERE IS ANY WRONG PLEASE CORRECT ME.

Thanks,
Babu

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In warehouses how many schemas are there?

1010

What is a repository? And how to add it in an informatica client?

1082

explain about unit testing? in real time?

2134

How to do unit testing in informatica? How to load data in informatica ?

1048

Partition, what happens if the specified key range is shorter and longer

2433

Is it possible to define a single node as a Gateway node as well as worker node?

1058

What is rank transform?

941

In how many ways we can create ports?

1067

How many dimensions are there in informatica?

1023

Is it possible to use a client with different version than that of its Informatica server?

1075

What is meant by query override?

1005

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6354

explain abt ur project architecture?

2122

How big was your fact table

1743

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2468