my source having 10 records but how can i load 20 records in
target, i am not bother about duplicates?

Answer Posted / naga

Just run the session twice , Setting Session update
properties as Insert and remove distict option/Unique key
constraints in Target

Is This Answer Correct ?    13 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4783


What is aggregator transformation in informatica?

545


Can you use flat files in Mapplets.

2224


Define joiner transformation?

596


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

1695






What is informatica?

680


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9166


difference between repository database and repository service?

624


whats the logic to load the lower level of granularity of data to fact table.

1803


Write the unconnected lookup syntax and how to return more than one column.

597


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1256


Explain joiner transformation in informatica

668


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8561


Which transformation should we use to normalise the COBOL and relational sources?

747


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2139