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
draw informatica architecture 8.6 ?
What is a rank transform?
Define update strategy?
what is informatica metadata?
What are the main issues while working with flat files as source and as targets ?
What is incremental aggregation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is a passive transformation?
Where do we use mapping variables in informatica?
What is an Integration service in Informatica?
What is the procedure for creating independent data marts from informatica 7.1?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Differentiate between Load Manager and DTM?
define galaxy repository in informatica
Which means the first record should come as last record and last record should come as first record and load into the target file?