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

What are session parameters ? How do you set them?

0 Answers  

what is the difference between mapplet & stored procedure?

1 Answers  

what is the exact meaning of domain?

3 Answers  

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

Does an informatica transformation support only aggregate expressions?

0 Answers  




what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

0 Answers  

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories