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

In which scenario did you used pushdown optimization?

1 Answers  

Diff b/w ShortCut and reusabel Object ?

4 Answers  

Where do we use mapping variables in informatica?

0 Answers  

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  




in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

When do you use mapping parameters? (In which transformations)

1 Answers  

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

what is normalizer transformation?

4 Answers   Wipro,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  

what is session override?

2 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories