Interested to Buy Any Domain ? << Click Here >> for more details...
How to handle changing source file counts in a mapping?
- 3 Answers
- 19123 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 |
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
Describe the impact of several join conditions and join order in a joiner transformation?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
How to load the source table into flat file target(with columns) in informatica?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
how to sort date field in infomatica?
what is size of u r database?
what is a time dimension? give an example?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
When we are using Dynamic Cache,which options we will select in session level?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
Teradata 
