in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?

Answer Posted / pavana

You can use sequence generator and then in exp trn, use a
variable which reads the 1st number the seq generates and
use filter transformation and take only 1st generated row
and +10th record.

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

expain about the tune parameters?

2173


According to his methodology what all you need before you build a datawarehouse

1451


Explain what are the different versions of informatica?

892


Enlist the tasks for which source qualifier transformation is used.

797


How to load a Dimension ? and how to load a fact table?

1165


How do you take back up of repository?

938


In development project what is the process to follow for an etl developer from day1

1499


How to create a non-reusable instance of reusable transformations?

909


What is complex mapping?

892


What are the different options available for update strategy?

790


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2151


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

902


What is meant by query override?

845


Explain the tuning lookup transformation - informatica

804


What are active and passive transformations?

845