How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

Answer Posted / vijaya

above answer only for the first time data loading only for new
record inserts to source it gives false results

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In how many ways we can create ports?

698


COM components can be used in Informatica

1871


How to load data in informatica ?

568


Can informatica load heterogeneous targets from heterogeneous sources?

693


When do you use sql override in a lookup transformation?

582






Explain in detail scd type 2 through mapping.

609


How to create Target definition for flat files?

752


What is a repository? And how to add it in an informatica client?

646


What is different between the data warehouse and data mart?

628


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7763


How to join three sources using joiner? Explain though mapping flow.

693


What is the commit type if you have a transaction control transformation in the mapping?

650


How to elaborate powercenter integration service?

647


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1467


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

1682