i hav a scenario like this i want load data from source to target as follows

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

Question Posted / vasu.m

1 Answers
3412 Views
I also Faced
E-Mail Answers

i hav a scenario like this i want load data from source to target as follows frist it counts the ..

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

Post New Answer

More Informatica Interview Questions

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers

Issue with Update override at Target table in Informatica.

2 Answers

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers

What is the use of target designer?

0 Answers

what are the reusable tasks in informatica ?

11 Answers CTS, HP, IBM, TCS,