wat transf shud i use to achieve this
id sal id sal sum
src-1 20 tgt 1 20 40
1 20 1 20 40
2 15 2 15 35
2 20 2 20 35
- 2 Answers
- 4443 Views
- I also Faced
- E-Mail Answers
Answer Posted / uma
Source -> SQ -> Agg T/F to get sum (group by id) -> Joiner (to join SQ and output of aggr transformation) -> Target
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Write the unconnected lookup syntax?
How can we improve session performance in aggregator transformation?
What is the benefit of partitioning a session?
What are the differences between a connected lookup and unconnected lookup?
What if the source is a flat-file?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what is diff b/t sorter t/r and agg have the option sorter property...
What is a connected transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are ETL Tools?
How do you convert single row from source into three rows into target?
How identifying bottlenecks in various components of informatica and resolving them?
