how can u avoid duplicate rows in flat file?
Answer Posted / radhakrishnansk
sorted transformation
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
What is a repository? And how to add it in an informatica client?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is parallel processing in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the surrogate key?
What is the need of etl tools?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the new features of Power Center 5.0?
What is resilience time?
What is the cumulative sum and moving sum?
What is informatica metadata and where is it stored?
What are the new features of informatica 9.x at the developer level?