Answer / akash

This scenario can also be implemented by using the
following query in Source Qualifier:

select * from table_name where rowid not in (select rowid
from table_name where rownum <= 10)

This will give the records after 10

Answer / ajit

use sequence generator with port key to source rows and then
use filter condition key>11

Answer / prabhu

If it a flat file u can use initial no of rows to skip
property while creating source definition.We can set it to
11 so that informatica will skip 11 rows while reading from
source

Prabhu
www.iskilltech.com

Answer / murali gundeti

use sequence generator with port key to source rows and then
use filter condition key>10

Answer / krish

take expression in exp take variable port(v1.......v1+1)and
take output port(in that give v1)send this o/p port to
router give the condition as v1>11.

Answer / guest

it is not possible to take data from 11th records. because
consider this senario.. if u give select statement as
select column name1,2.... from table name where rownum<5;

this select statement wil work if u have 10 or more than 5
records in table.

now u r asking to load only from 11th record

so the query will be like this

select column name1,2,.... from table name where rownum>10;

it wil return emptyset only..

see the checking condition. it wil fetch the 1st record and
check rownum 1 > rownum 10. condition failed. so it wont go
to second record and results in empty set.

but in earlier case it wil fetch 1st record and checks
rownum 1 < rownum 5. condition satisfied. it wil load that
row and check for 2nd row and 3rd and so on until the
condition fails.

once the condition fails it wil come out.

what is informatica metadata?

0 Answers  

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

What is power play plug in?

2 Answers  

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

What is informatica worklet?

0 Answers  

What is aggregate cache in aggregator transforamtion?

5 Answers  

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

Without source how to insert record to target?

6 Answers  

What are Business Components in Informatica?

1 Answers