I have a scenario with lookup table. in that lookup table have
colomns, but i need to process only 10 colomns out of 50.
Please te me how can we acheive it?
Answer Posted / srinivasarao
we can use look up over ride
Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
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.
How you know when to use a static cache and dynamic cache in lookup transformation?
How can we store previous session logs?
What are the different components of powercenter?
What is the function of look up transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How to create or import flat file definition in to the warehouse designer?
What is the difference between informatics 7x and 8x and what is latest version?
How do you update the records with or without using update strategy?
Which files are created during the session rums by informatics server?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Describe data concatenation?
Clarify the aggregator change?
how we can load rejected record's at run time?(not through bad files)
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.