what is difference between dimention table and fact table?
Answer / guest
dimensional table stores the textual description of data
whereas fact table stores numerical values.
| Is This Answer Correct ? | 12 Yes | 3 No |
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
how tokens will generate?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
What are active and passive transformations?
What are the new features in Informatica 5.0?
How can you recover the session in sequential batches?
Why filter transformation is an active one?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
can we generate reports in informatica ? How?
How do you update the records with or without using update strategy?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?