Interested to Buy Any Domain ? << Click Here >> for more details...
if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 8990 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandra
After the source qulifier take Aggr t/r pass all the ports
to th Aggr t/r. group by eno & year.Add a new out put port
in this derive the logic as sum(sal) & pass to the Target
Def.
I think this would work.
Regards,
Chandra
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain Dataware house architecture .how data flow from intial to end?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is meant by lookup transformation? Explain the types of lookup transformation?
What is session task and command task?
State the limitations where we cannot use joiner in the mapping pipeline?
What is rank transform?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is the commit type if you have a transaction control transformation in the mapping?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How do you load first and last records into target table?
update strategy transformation in informatica
tell me the rules and responsblites in our project(my project is development)
how we can load rejected record's at run time?(not through bad files)
if we have a delimiters at unwanted places in a flat file how can we over come those.
How you prepared reports for OLAP?
