If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001?
Answer Posted / rao
one option is session recovery.
or
select * from select rownum from tablenaem) where rownum>10000
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is status code in informatica?
What are the performance considerations when working with aggregator transformation?
What is meant by active and passive transformation?
What is union transformation in informatica?
How do you load unique records into one target table and duplicate records into a different target table?
Where is metadata stored?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
list out all the transformations which use cache?
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 would you copy the content of one repository to another repository?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is sequence generator transformation in informatica?
How to partition the Session?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N