SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT
BUSINESS LOGIC WE CAN APPLY.
source table target table
------------ ------------
c1 c2 c3 c1 c2 c3
-- -- -- -- -- --
1 A J 1
2 B K 2 A
3 C L 3 B J
4 D M 4 C K
5 E N 5 E L
F M
N
- 1 Answers
- 2225 Views
- Infotech, I also Faced
- E-Mail Answers
Answer / Bharat Babu Agrawal
Based on the given source and target table format, we can apply the following business logic:n
1. Flatten: Transform the source table into a flat table where each row is a separate record.n
2. Group By: Group the flattened records by their corresponding primary key (c1 in this case).n
3. Aggregate: Summarize the values of columns c2 and c3 for each group.n
4. Output: Write the summarized results into the target table format.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is fact table?
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
What is the difference between procedure and stored procedur?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
How can we use batches?
Differentiate between mapping parameter and mapping variable?
What is a command that used to run a batch?
What are data-driven sessions?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
Can anyone tell me the new features in Informatica 9 Version?
Teradata 
