I have Employee table, 10 cols are connected to next
transformation, only 4 cols are selected in SQL override.
What would be passed to next col.
Answer Posted / smith
Only those 4 columns in the sql override will be passed to
the next transformation.
| Is This Answer Correct ? | 2 Yes | 15 No |
Post New Answer View All Answers
What are the main features of Oracle 8i with context to datawarehouse?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
expain about the tune parameters?
Differentiate between a repository server and a powerhouse?
What is the surrogate key?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
explain about unit testing? in real time?
What are the components of workflow manager?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to configure mapping in informatica?
What do you mean by enterprise data warehousing?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the fact table?