Answer Posted / shital.mylove@gmail.com
4 different types of facts
1.Addictive
2.Semi Addictive
3.Non Addictive
4.Factless Fact Table
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are active and passive transformations?
waht type of interface is used for testing the data in informatica
How do you load first and last records into target table?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is a grid in Informatica?
Enlist some properties of sessions.
What is the commit type if you have a transaction control transformation in the mapping?
Can you use flat files in Mapplets.
How do you load only null records into target? Explain through mapping flow.
What is union transformation in informatica?
What is the use of target designer?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Mention some types of transformation?
On which transformations you created partitions in your project?