We can use an aggregator. Dont to group by on any of the columns. Add one

How to handle changing source file counts in a mapping?

Question Posted / priyank

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we override a native sql query within informatica?

624

Can we create two repositories on same database instance in oracle?

603

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

7771

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1586

How would you copy the content of one repository to another repository?

548

How to convert multiple rows to single row (multiple columns) in informatica

889

On which transformations you created partitions in your project?

759

What do you mean by worklet?

624

Explain sql transformation in script mode examples in informatica

597

How can we remove the duplicates from flat file source?

571

Enlist the differences between database and data warehouse.

543

 Informatica Checkpoints

2849

list out all the transformations which use cache?

683

What is native users?

717

How to create the source and target database connections in server manager?

618