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
- 5681 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 is an unconnected transformation?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?
What all join we can perform in LOOKUP transformation?
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What is an aggregator transformation? it is active why cant it be passive explain?
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.
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
In which circumstances that informatica server creates Reject files?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
What is the difference between a repository server and a powerhouse?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
Teradata 
