how can u avoid duplicate rows in flat file?
Answer Posted / sunil
In a sorter transformation select distinct option to avoid
duplicates in a flat file
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
If informatica has its scheduler why using third party scheduler?
what is index?how it can work in informatica
How to do unit testing in informatica? How to load data in informatica ?
Which transformation is needed while using the Cobol sources as source definitions?
What is confirmed fact in dataware housing?
What are the types of caches in lookup?
what is diff b/t sorter t/r and agg have the option sorter property...
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is a rank transform?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Which version configuration tool used in ur project?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How an expression transformation differs from aggregator transformation?
How to load the data from people soft hrm to people soft erm using informatica?