Interested to Buy Any Domain ? << Click Here >> for more details...
Flat file heaving 1 lack records and I want to push 52000
records to the target?
- 7 Answers
- 15296 Views
- I also Faced
- E-Mail Answers
Answer Posted / pushpa
you have 100000 records and you want to load 52k records in
the target. then,
source definition--> source qualifier-->target definition.
open source qualifier properties select SQL query,in that
field generate the query with WHERE clause rownum<=52000. and
run the session.
| Is This Answer Correct ? | 6 Yes | 20 No |
Post New Answer View All Answers
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the types of lookup transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How can a transformation be made reusable?
How can we remove the duplicates from flat file source?
What are the new features of Power Center 5.0?
Define update strategy?
Under what condition selecting sorted input in aggregator may fail the session?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
How do you migrate data from one environment to another?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to handle decimal places while importing a flatfile into informatica?
Did u used latest transformations of 8.6.0? for what?
What is a passive transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
