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 |
In update strategy target table or flat file which gives more performance ? why?
What is power play plug in?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
difference between source based commit? and target based commit? which is better with respect to performance?
Without using any transformations how u can load the data into target?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
If you want to create indexes after the load process which transformation you choose?
How do you join more than 3 flat files in informatica?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
How you know when to use a static cache and dynamic cache in lookup transformation?
What if the source is a flat-file?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com