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

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1592


What are the main features of Oracle 8i with context to datawarehouse?

1749


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4376


Explain sessions and how many types of sessions are there?

652


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

862






How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1670


What are the different components of powercenter?

653


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1875


What you know about transaction control transformation?

620


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1730


Explain what are the different versions of informatica?

729


What is the format of informatica objects in a repository?

671


How you can differentiate between connected lookup and unconnected lookup?

683


How do we call shell scripts from informatica?

648


how many types of dimensions are available in informatica?

627