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
Answer Posted / chiky
for getting max vales, go for aggregate.. and not for
lookup.
after taking max values using aggregate, using dummy
columns join agg value and your source table value..
after that you can have your lookup what ever needed.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the data movement modes in informatica?
What is fact table? Explain the different kinds of facts.
Why update strategy and union transformations are active?
Explain the types of lookup transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How do you take back up of repository?
What are the different types of repositories created using informatica?
What is the meaning of up gradation of repository?
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.
How we can use union transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Name at least 5 different types of transformations used in mapping design and state the use of each.?