How to handle changing source file counts in a mapping?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is the difference between copy object import objects using repositery manager which one is best
What is union transformation in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
Slowly changing dimensions, types and where will you use them
What is the function of aggregator transformation?
What are two types of processes that informatica runs the session?
How to convert flat file into xml file? How to tune joiner?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
what is metadata?
How can you join two tables without any common column present in them?
differences between service based and product based?