Interested to Buy Any Domain ? << Click Here >> for more details...
How can we eliminate duplicate rows from flatfile,explain?
- 3 Answers
- 11859 Views
- I also Faced
- E-Mail Answers
Answer Posted / veera reddy
By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What are the static cache and dynamic cache in informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What do you mean by blocking transformation?
What is blocking transformation?
What does role playing dimension mean?
Briefly define a session task?
Differentiate between a repository server and a powerhouse?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
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?
What is informatica? Why do we need it?
What is meant by active and passive transformation?
What is aggregate cache in aggregator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
How can you define user defied event?
Why is sorter an active transformation?
