1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi All,

I've 110 records in my table but 101 records contains an
error. When I run the session, I want to load the 100
records into the target. Can anyone suggest me the best
solution for this...


Thanks in Advance,

Question Posted / ankit gupta

Answer Posted / ankit gupta

set commit interval as 100 in WF session and commitType as
target

Is This Answer Correct ?    15 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between stop and abort in informatica

666

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055

Explain the etl program with few examples.

548

can you please explain me pre session and post session options?

6387

How do you handle two sessions in Informatica

669




how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1976

How do we call shell scripts from informatica?

600

How might you approve all mappings in the archive all the while?

602

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1416

What is decode in informatica?

659

Explain your project of banking domian.

1220

How would you copy the content of one repository to another repository?

561

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

1697

What are the conditions needed to improve the performance of informatica aggregator transformation?

585

What is the need of an ETL tool?

644