what is semi-additive fact?where did u used?
Answers were Sorted based on User's Feedback
Answer / ramana
The fact value decided by some of the dimensions values,then that fact is called semi additive fact.
| Is This Answer Correct ? | 0 Yes | 0 No |
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
How to delete the (flat file) data in the target table after loaded.
How can u work with remote database in informatica?did you work directly by using remote connections?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
what is bitmap index? did u use it?and how to use it in informatica
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
What is the difference between stop and abort in informatica
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What are connected or unconnected transformations?
How the informatica server sorts the string values in Rank transformation?
In which transformation you cannot drag ports into it?