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 |
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What is difference macros and prompts?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
waht type of interface is used for testing the data in informatica
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
what are the differences between powercenter 8.1 and powercenter 8.5?
Router T/R is active but some people are saying it is also passive which is exactly right?
WHAT IS FACT TABLES?
how to get flatfile containg 10 records half records one target another half another target
What is a candidate key?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)