Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate duplicates from flat file..what is the
procedure
- 4 Answers
- 8347 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil
To eliminate duplicates from flat file use sorter in that
select distict option...it will work
| Is This Answer Correct ? | 26 Yes | 0 No |
Answer / ram
one more answer is ....
use an aggeregator transformation and select all ports
as 'group by'...then u will get distinct records...
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / paulo coelho
In an Unix environment, do:
page YourFile | sort | uniq -c
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / muddam
Select all ports as group by then Create one o/p o_count in
aggregater(o_count>1). Before this you wolud have taken one
sorter trans for sorted data.
It will work out.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
What are the components of the workflow manager?
What are data-driven sessions?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
What is the default source option for update stratgey transformation?
Explain pushdown optimization and types in informatica
How to delete the data in the target table after loaded.
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
what is constraint based load order
Teradata 
