without dynamic lookup how to insert new rows and update
existing rows?
What is a dimensional model?
Explain the etl program with few examples.
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
what is the need of session partitioning... how it is useful in real time
What are the tasks that source qualifier performs?
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
What is main use of mapplet?
How we can create indexes after completing the loan process?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
why u go for dimensions ?
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 .
what is shortcut in informatica? difference between shortcut,reusable object?