How to handle changing source file counts in a mapping?
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 let me know how to make encryption and decryption with example?
What is dimensional table? Explain the different dimensions.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is a pre-defined event and user-defined event?
Explain what are the different versions of informatica?
What are the transformations that are not supported in mapplet?
Explain pushdown optimization $pushdownconfig parameter - informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can we override a native sql query within informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain the different lookup methods used in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to delete duplicate row using informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?