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
4263 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

when we go for unconnected lookup transformation? and why?

5 Answers Accenture,

What are the different types of Type2 dimension maping?

2 Answers CTS,

Tell me about informatica architecture.

2 Answers TCS,

Which will beter perform IIf or decode?

3 Answers TCS,

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers

What are Dimensional table?

0 Answers Informatica,

Explain the types of lookup transformation?

0 Answers

From where we can start or use pmcmd?

3 Answers

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers Accenture,

tell me the push down optimization

2 Answers Wipro,

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers TCS,

What is the Difference between sorter and aggregator?

2 Answers

For more Informatica Interview Questions Click Here