How to handle changing source file counts in a mapping?

Answers were Sorted based on User's Feedback



How to handle changing source file counts in a mapping?..

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.

Is This Answer Correct ?    3 Yes 1 No

How to handle changing source file counts in a mapping?..

Answer / azhar

Simple use v_port in Expression

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

Is This Answer Correct ?    1 Yes 1 No

How to handle changing source file counts in a mapping?..

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

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More Informatica Interview Questions

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  


What is source qualifier?

6 Answers   SDS,


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  


what is datamart

4 Answers   IBM, Informatica,


How do you recover rows from a failed session

1 Answers  


wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  


what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,


what is incremental data aggregation?

3 Answers   IBM,


If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,


As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  


How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,


Write the unconnected lookup syntax and how to return more than one column.

0 Answers  


Categories