Answer Posted / gangam rajesh
using joiner transformation
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the settings that you use to configure the joiner transformation?
what is size of u r database?
What are the different clients of powercenter?
What is the difference between router and filter?
How you can differentiate between connected lookup and unconnected lookup?
How we can create indexes after completing the load process?
Design a mapping to load a target table with the following values from the above source?
What is the function of union transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Differentiate between joiner and lookup transformation?
Mention few power centre client applications with their basic purpose?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
explain abt ur project architecture?