Hey I am net to informatica? Can any one explain me step by
step How scd will work ?
- 1 Answers
- 6809 Views
- Infosys, I also Faced
- E-Mail Answers
Selects all rows.
Caches the existing target as a lookup table.
Compares logical key columns in the source against
corresponding columns in the target lookup table.
Compares source columns against corresponding target
columns if key columns match.
Flags new rows and changed rows.
Creates two data flows: one for new rows, one for changed
rows.
Generates a primary key for new rows.
Inserts new rows to the target.
Updates changed rows in the target, overwriting existing
rows.
| Is This Answer Correct ? | 6 Yes | 2 No |
How to partition the Session?
tell me 5 session failure in real time how can you solve that in your project?
What is a difference between complete, stop and abort?
Howmany ways yoU can update a relational source defintion and what are they?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
replace multiple spaces with single space.
How can you generate reports in informatica?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
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 can a transformation be made reusable?
can you use flat file for repository?why?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Teradata 
