Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 is session parameters?

1 Answers   Cap Gemini,


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  


Which version configuration tool used in ur project?

0 Answers   CTS, TCS,


What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  


how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,






what is the difference between stop and abort?

3 Answers   TCS,


Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,


Difference between session variables and workflow variables?

2 Answers   Informatica,


how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,


if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  


All active transformations r passive or not?

7 Answers  


why we need informatica

2 Answers   HCL,






Categories