What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Answer Posted / 9019
Sorter select distinct, aggregator group by columns
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the features of connected and unconnected lookup.
Whats there in global repository
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
how tokens will generate?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How does a rank transform differ from aggregator transform functions max and min?
lookup transformation with screenshots
how we can load rejected record's at run time?(not through bad files)
What is the need of an ETL tool?
What is an Integration service in Informatica?
Explain why we use partitioning the session in informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Describe an informatica powercenter?