i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?

Answer Posted / chandra

you create a Rownum port in target system and use the Ex/T u create o_port in Expression edition give the logic is Rownum<=7



Its Right Or Wrong Please...........Tell me




Regards
Chandra

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How big was your fact table

1324


Mention a few design and development best practices for informatica?

563


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

564


What do mean by local and global repository?

709


How do you set a varible in incremental aggregation

1453






What are the data movement modes in informatica?

707


What are the types of lookup transformation?

636


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1540


How to partition the Session?

648


What is update strategy transform?

580


tell me the rules and responsblites in our project(my project is development)

1508


Please let me know how to make Data masking in informatica..

1273


What is the difference between a connected look up and unconnected lookup?

578


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

554


What are pre and post-session shell commands?

748