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

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,


HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,


suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   TCS, ITC Infotech,


What happens when a session fails and you click on recover?

0 Answers  


Roles and Responsibilties of Informatica Production Support Member?

6 Answers  






Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  


&#61656; Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   Infotech, IBM,


How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,






Categories