Interested to Buy Any Domain ? << Click Here >> for more details...
How to handle changing source file counts in a mapping?
- 3 Answers
- 19454 Views
- Deloitte, TCS, I also Faced
- E-Mail Answers
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 |
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
can we override a native sql query within informatica? How do we do it?
What is Data Caches size?
What are the advantages of using informatica as an etl tool over teradata?
What is the Rank index port in Rank transformation?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
What is the session task and command task?
In a sequential batch can u run the session if previous session fails?
How to add source flat file header into target file?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
Teradata 
