1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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


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 do you use sql override in a lookup transformation?

0 Answers  

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

How to delete duplicate records in a flat file source?

2 Answers  

difference between repository database and repository service?

0 Answers  




hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

Why update strategy and union transformations are active? Explain with examples.

0 Answers  

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

What are mapplets?

0 Answers  

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

Implementation methodology

0 Answers  

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories