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.

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

Have you worked with/created Parameter file

0 Answers  

What is joiner change?

0 Answers  

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

which one is better performance wise joiner or look up

0 Answers   Informatica,

What is the use of code page?

0 Answers  

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

what is incremental aggregation ,with example?

2 Answers