how we can do session partition in informatica any one explain
me clearly?
thanks advance.
Answer / raghu
partion points make the boundaries btn threads
in a pipe line.the integration service redistributes the data
at partion points.we can increase the partion points and
increase the session performance.
| Is This Answer Correct ? | 3 Yes | 1 No |
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
What are the advantages of using informatica as an etl tool over teradata?
how to remove staging area
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
why union is active transformation?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
What are the different components of powercenter?
What is different between the data warehouse and data mart?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.