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

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

Question Posted / balakrishna.manam

1 Answers
7095 Views
IBM, I also Faced
E-Mail Answers

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

Mention few advantages of router transformation over filter transformation.

0 Answers

why we need informatica

2 Answers HCL,

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers Rolta,

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers HP,

Explain pmcmd command usage in informatica

0 Answers Informatica,

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers

what is plsql table?

2 Answers

How does a rank transform differ from aggregator transform functions max and min?

0 Answers

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers Cap Gemini,

is it possible to index the data in cache of lkp transformation ?

0 Answers

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers Amdocs,

For more Informatica Interview Questions Click Here