Interested to Buy Any Domain ? << Click Here >> for more details...
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
- 1 Answers
- 1529 Views
- I also Faced
- E-Mail Answers
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 where to store informatica rejected data? How to extract the informatica rejected data?
What are the types of caches in lookup? Explain them.
What is meant by lookup transformation? Explain the types of lookup transformation?
How to configure mapping in informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to update source definition?
list out all the transformations which use cache?
How you can differentiate between connected lookup and unconnected lookup?
What is rank transform?
How to generate sequence numbers using expression transformation?
explan ur project architecture?
lookup transformation with screenshots
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?
Is stop and abort are same in informatica?
