Answer / kamlesh mishra

The PowerCenter Server skips the specified number of rows
before reading the file. Use this to skip header
rows in the file.
And for last rows implement following logic.

1) Take sorter transformation reverse the rows on the basis of some key field like empno.
2)take expr transformation add nextval from sequence generator
3) Take filter transformation add condition nextval !=1 .
4)(optional)reverse the rows again using sorter transformation.
5) From filter to tgt connect the respective ports.

Src---->SQ--->SORTER--->EXPR---->FILTER---->SORTER---->TGT

Answer / allen

Skipping the firt row in a flat file is easy:
The PowerCenter Server skips the specified number of rows
before reading the file. Use this to skip title or header
rows in the file.

Skipping the last row is not as easy. In my case, the last
row was a record count. I was able to check ports that
shouldn't be null, spaces or zeros and reject the row. The
LENGTH function can also be used to check the length of
data. Delimited or not has to be considered in any checks.

Answer / manoj subramanian

I have done it using sequence generator,rank and filter transformation.
Filtering first record:
Generated sequence no using sequence transformation and given
as input to rank transformation.In properties selected
top and no of ranks as maximum rank allowed in informatica
then followed by filter transformation with filter condition
as rankindex<>1.
Filtering last Record:
Followed by another set of rank and filter wit rank property as bottom.

Answer / sagarreddy

in source qualifier your using this query like this u get it
easily
select rowid from tablename
minus
(select min(rowid) from tablename
union
select max(rowid) from tablename )
if u write this query will work it plz go through it

Answer / maneesh

To eliminate first row, simply use a counter in Expression and then Filter.

To eliminate the last row, make two pipelines with the same source
In first pipeline, use AGGREGATOR without any Group By ports In second pipeline, join it with the above with JOINER. Use and Outer Join and then other than that Joined row .. load all the rows.

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

How to extract sap data using informatica?

0 Answers  

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

select count(1) from emp? what is the o/p?

5 Answers   TCS,

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers