Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4265 Views
- I also Faced
- E-Mail Answers
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
Explain the pipeline partition with real time example?
What are the tasks that source qualifier perform?
Under which circumstances, informatica server creates reject files?
What is aggregate cache in aggregator transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the benefit of partitioning a session?
What if the source is a flat-file?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is pmcmd command?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain lookup transformation source types in informatica
what is unit testing?tell me proceedure
What is the difference between STOP and ABORT options in Workflow Monitor?
