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 / 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 are the types of Data warehousing ?
Explain what is informatica metadata and where is it stored?
How to identify this row for insert and this row for update in dynamic lookup cache
How do you use reject loader.
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
what is system requirement(SR) & business requirement(BR)?
How can we get two output ports in un-connect transformation?
Write the different tools in the workflow manager?
How can we remove the duplicates from flat file source?
what is size of u r database?
What is the difference between writing a joiner query in ANSI style and THETA style?