how eliminate the duplicates in flat file with out using
sorter ,aggregater
Answer Posted / krishna
The source qualifier Trns has select distinc option from thr we can eliminate duplicates
| Is This Answer Correct ? | 6 Yes | 38 No |
Post New Answer View All Answers
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?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
what is SDLC way of code development?
Define the various join types of joiner transformation?
What is target load order?
What is fact table? Explain the different kinds of facts.
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 meant by pre and post session shell command?
What are multi-group transformations?
Mention some types of transformation?
How you can differentiate between connected lookup and unconnected lookup?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
design of staging area?
Briefly describe lookup transformation?