what is the process we used in joiner transformation,there
is no matching column in sources?
Answers were Sorted based on User's Feedback
Answer / emmanuel
Create a dummy port in both the sq transforamtion and join
based on the dummy values
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / anithaks
I think we can use Union Transformation in such case!!
| Is This Answer Correct ? | 0 Yes | 8 No |
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
list out all the transformations which use cache?
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
Enterprise data warehouse your projects phase by phase explain?
Define error Threshold?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
What is informatica? What exactly are the practical uses in real world
what is incremental data aggregation?
how to through logic of informatica using the push down optimization into oracle.
Why we need XMLs?
How will you check the bottle necks in informatica? From where do you start checking?
What are the features of complex mapping?