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




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

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

0 Answers  


Can you create a flatfile target

3 Answers   ABC,


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,


Enlist the advantages of informatica.

0 Answers  


what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  






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

2 Answers  


What are the reusable transforamtions?

1 Answers  


what is the difference between repository & Intergration service

1 Answers  


What all are steps in up gradation of Informatica server?

0 Answers  


can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,


wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  


How does a rank transform differ from aggregator transform functions max and min?

0 Answers  






Categories