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 |
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
I have a flat file, want to reverse the contents of the flat file
major difference between normal loading and bulk loading?
where actually the usage of push down optimization happens...
What you know about transaction control transformation?
what is diff between IN and EXIT commands
what is polling?
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
how to create a sample mapping for dynamic lookup transformation
What aer the out put files that the informatica server creates during the session running?
What is Collect performance data in informatica and what is the use of it.