Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 5722 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What are the types of maping in Getting Started Wizard?
What is olap (on-line analytical processing?
How can you access the remote source into your session?
Which is costliest transformation? costly means occupying more memory?
What are the types of schemas we have in data warehouse and what are the difference between them?
Which transformation is needed while using the Cobol sources as source definitions?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
What is option by which we can run all the sessions in a batch simultaneously?
What is difference between Mapplet and reusable transformation?
How to update a particular record in target with out running whole workflow?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
Where is metadata stored?
Teradata 
