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



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

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,


Where do you create/define mapping parameter and mapping variable?

1 Answers  


what is polling?

1 Answers   Informatica,


what we require for D.modelling?

1 Answers  


I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,


How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,


Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,


What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  


Can we create a Integration service without a Repository service and vice versa?

0 Answers  


Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  


when informatica 8 series released ?

1 Answers   IBM,


What is IQD file?

1 Answers  


Categories