Interested to Buy Any Domain ? << Click Here >> for more details...
how do u fnd the duplicate rows and how to delete the
duplicate rows?
- 2 Answers
- 8386 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sankar
repet(more then one time) the rows is duplicate rows,
there r many ways to dele the duplicate rows
1.in source qualifies t/r select the DISTINC option
2.in aggreter t/r select the group by port
3.in sorter t/r select the distinc
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is the difference between router and filter?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
What are the static cache and dynamic cache in informatica?
How many numbers of sessions can one group in batches?
What are the differences between joiner transformation and source qualifier transformation?
What is workflow? What are the components of workflow manager?
What is the command used to run a batch?
What is union transformation in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
What are the different types of repositories created using informatica?
Quickly characterize reusable change?
During the running session, output files are created by informatica server. Enlist few of them.
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 ?
