How to handle changing source file counts in a mapping?

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

How can we use mapping variables in informatica? Where do we use them?

0 Answers  


How to load relational source into file target?

3 Answers   IBM,


what are presession,postsession success and postsession failure commands ?

1 Answers  


how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,


What is power play plug in?

2 Answers  


Explain why we use partitioning the session in informatica?

0 Answers  


How to run a session, which contains mapplet?

1 Answers  


difference between shortcut and reusable transformation?

2 Answers  


Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  


What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  


hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  


Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  


Categories