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

in which situations do u go for sequence generator ?

2 Answers   TCS,

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

how can we use sorter transformation in joins?

5 Answers   IBM,

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  




any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  

How is Data Models Used in Practice?

1 Answers  

Explain target update override in informatica

0 Answers   Informatica,

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories