How to handle changing source file counts in a mapping?

Question Posted / rajat

3 Answers
19301 Views
Deloitte, TCS, I also Faced
E-Mail Answers

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

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers iGate, Qualcomm,

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers CTS,

what are the transformations that restricts the partitioning of sessions?

1 Answers

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers IBM,

What is a sorter transformation?

0 Answers Informatica,

how to move the mappings from your local machine to claint place?

2 Answers

what happens when a batch fails?

3 Answers

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers Informatica,

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers Cap Gemini,

What are the restrictions of union transformation?

0 Answers

what are challenges that you faced in testing? give solution to it?

1 Answers

wht is cdc?how to use it in creation of mappings?

6 Answers HSBC,

For more Informatica Interview Questions Click Here