How can we eliminate duplicate rows from flatfile,explain?
Answer Posted / seshagiri
veere reddy,
Dynamic lookup will not work for flat file only static
lookup will work for a flat file
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Clarify the utilization of aggregator cache record?
What is the difference between source qualifier transformations source filter to filter transformation?
what is the hint? how to use it to reduce the query processing in program?
Partition, what happens if the specified key range is shorter and longer
How can we use batches?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What do you mean incremental aggregation?
Explain the use of aggregator cache file?
What is the need of an ETL tool?
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?
Explain lookup transformation in informatica
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the use of code page?
What is transformation?
Slowly changing dimensions, types and where will you use them