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
What is a repository? And how to add it in an informatica client?
What are the databases that informatica can connect to windows?
What are the measure objects?
What is meant by query override?
Where are the source flat files kept before running the session?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
To import the flat file definition into the designer where should the flat file be placed?
In informatica workflow manager, how many repositories can be created?
Mention few power centre client applications with their basic purpose?
server hot-ws270 is connect to Repository B. What does it mean?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Which transformation is needed while using the Cobol sources as source definitions?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the types of caches in lookup? Explain them.