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

If one flat file contains n number of records., we have to
load the records 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 of records., we have to load the records in target from 51 to 10..

Answer / reena

use sequence generator to get row no. for each record ,then
use filter giving the condition (row no.greater than 50 and
less than 100)

Is This Answer Correct ?    14 Yes 3 No

If one flat file contains n number of records., we have to load the records in target from 51 to 10..

Answer / chakri

Use count variable

Use Variable port

Expression transformation

(Count>50) and (count<100)

Please let me know any information

Is This Answer Correct ?    6 Yes 3 No

If one flat file contains n number of records., we have to load the records in target from 51 to 10..

Answer / gurava reddy

Source-SQ-SEQ-FILTER-TARGET

1.Connect the sequence genarater(NEXTVAL) to filter in filter

IIF(NEXTVAL>=50 and NEXTVAL>=100,TRUE, FALSE)

2. Then connect the ports to destination(Target)

Is This Answer Correct ?    2 Yes 0 No

If one flat file contains n number of records., we have to load the records in target from 51 to 10..

Answer / palani

Yes. For better performance filter the records using Unix's
Head,Tail commands. Pass the particular records to SQ and
Load.

Is This Answer Correct ?    0 Yes 0 No

If one flat file contains n number of records., we have to load the records in target from 51 to 10..

Answer / susanta

We can filter the records in UNIX itself, then we can use
that filterd file as a source to the mapping.

Is This Answer Correct ?    0 Yes 1 No

If one flat file contains n number of records., we have to load the records in target from 51 to 10..

Answer / sujana

i dont think count works in dis scenario...first answer works

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

why we are using surogate key in real time give me explanation

2 Answers   TCS,

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,




in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

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

0 Answers   Informatica,

why we use materialized view over view?

1 Answers   Zensar,

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories