i hav a scenario like this i want load data from source to
target as follows frist it counts the num of deptno and
display with that with count and how many times it reapts
along with all the records in source
Answer Posted / santha
for this scenario You can use the ANALYTIC function.It give
all the total count and individual count...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
Which transformation should we use to normalise the COBOL and relational sources?
What is a predefined event?
Explain your project of banking domian.
Describe data concatenation?
what is the complex transformation you used in informatica
What is Session and Batches?
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 will the document be delivered to me?
what is index?how it can work in informatica
What is a snowflake schema?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Differentiate between Load Manager and DTM?
in reporting we add some new objects,how we get the count of the newly added objects to the report
complex mapping ur project u r invlve can u explain and give real time example give me ?