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
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the main features of Oracle 8i with context to datawarehouse?
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
Explain sessions and how many types of sessions are there?
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?
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. ?
What are the different components of powercenter?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What you know about transaction control transformation?
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
Explain what are the different versions of informatica?
What is the format of informatica objects in a repository?
How you can differentiate between connected lookup and unconnected lookup?
How do we call shell scripts from informatica?
how many types of dimensions are available in informatica?