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 the surrogate key?
What is primary and backup node?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Can we change Dynamic to Static or Persistent cache? If so what happens?
tell me the rules and responsblites in our project(my project is development)
What is a code page?
Write the unconnected lookup syntax?
Can you generate sequence numbers without using the sequence generator transformation?
What is the sequence generator transformation in informatica?
Is it possible to revert a global repository to local one and why?
What is sequence generator transformation in informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
how to create user defined function (udf) in informatica
Explain Dataware house architecture .how data flow from intial to end?
Why sorter is an active transformation?