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
- 4094 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is status code in informatica?
how many session run unix environment what command using ?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
in which situations do u go for scds ?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Can anyone tell me the new features in Informatica 9 Version?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
how can we calculate fact table size?
What are the limitations of joiner transformation?
Teradata 
