i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Answer Posted / abhinaw prakash
You can make use of Variable ports for storing values
coming as input.For output you can compare values and give
the output.
the expression for output will look something like
IIF(Input_sal=v_prev_sal,v_prev_sal,input_sal+v_prev_sal)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is event and what are the tasks related to it?
explain abt ur project architecture?
what is song in infrmatica...?
What is a grid in Informatica?
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
what is size of u r database?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is aggregator transformation in informatica?
What is parallel processing in informatica?
What are the guidelines to be followed while using union transformation?
How do you set a varible in incremental aggregation
What is joiner transformation in informatica?
how tokens will generate?
what is Active lock explain
What is an aggregator transformation?