Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?

Question Posted / moorthi_cs

Answers were Sorted based on User's Feedback



If one flat file contains n number records., we have to load in target from 51 to 100.. how to use ..

Answer / hari

create mapping like

source -- sorter -- expression -- filter -- target.

here sorter is used to send data by ascending order data
this is not mandatory.

Expression is need to create variable port which will count
the rows which are comming in.

Filter having condition like if count value >=51 and count
value <= 100.

Is This Answer Correct ?    6 Yes 0 No

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use ..

Answer / venkateshmalneni

Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target

src--->sq---> expression--->filter--->target

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

How can we eliminate duplicate rows from flatfile,explain?

3 Answers  

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

What are the transformations that are not supported in mapplet?

0 Answers  

Explain what are the different versions of informatica?

0 Answers  

What are partitions in informatica and which one is used for better performance?

2 Answers  

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

how to create user defined function (udf) in informatica

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories