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 are junk dimensions?

0 Answers  

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

Two Default User groups created in the repository are ____ and ______

2 Answers  

How do you take back up of repository?

0 Answers  

what is the location of parameter file in informatica?

1 Answers   TCS,

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

what is mapping override?

2 Answers   Cap Gemini,

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers