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 want skip first 5 rows to load in to target? what will be
the logic at session level ??

Question Posted / balakrishna.manam


I want skip first 5 rows to load in to target? what will be the logic at session level ??..

Answer / nitin

The one way to skip records for relational sources would be
adding a SQL Query in session properties.

SELECT * FROM EMPLOYEE
MINUS
SELECT * FROM EMPLOYEE WHERE ROWNUM <= 5
This query would skip the first 5 records.

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More Informatica Interview Questions

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

What are the data movement modes in informatica?

0 Answers   Informatica,

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

How many numbers of sessions can one group in batches?

0 Answers  

What do you understand by SOA of Informatica?

0 Answers  

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

Differentiate between joiner and lookup transformation?

0 Answers  

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

how to we create datamart?

2 Answers   HSBC,

For more Informatica Interview Questions Click Here
Categories