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
How big was your fact table
Mention a few design and development best practices for informatica?
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??
What do mean by local and global repository?
How do you set a varible in incremental aggregation
What are the data movement modes in informatica?
What are the types of lookup transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to partition the Session?
What is update strategy transform?
tell me the rules and responsblites in our project(my project is development)
Please let me know how to make Data masking in informatica..
What is the difference between a connected look up and unconnected lookup?
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?
What are pre and post-session shell commands?