Answer / priyank

We can use an aggregator. Dont to group by on any of the
columns. Add one extra output port for Count. This port
will give the total count of the records in the source file.

Answer / azhar

Simple use v_port in Expression

v_port=0
v_port=v_port+1
for source file record count

Answer / suresh

we can maintain versions depends upon changes of sourece
file requirement

our current version is running source 1.1.0.0

if we have minor chages 1.1.0.1
if we have mazor chages 1.2.0.0

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

---

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

Define the various join types of joiner transformation?

0 Answers  

---

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

---

How do you take back up of repository?

0 Answers  

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

---

Can we create two repositories on same database instance in oracle?

0 Answers  

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

Briefly define a session task?

0 Answers  

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---