How can we eliminate duplicate rows from flatfile,explain?
Answers were Sorted based on User's Feedback
Answer / nagaraj.g
using sorter transformation for distinct in a flat files
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / veera reddy
By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.
| Is This Answer Correct ? | 6 Yes | 5 No |
Answer / 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 |
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
how to delete duplicate records by using filter transfermation?
what are the output files that the informatica server creats during running a session?
Filter transformation in the condition one of the data is NULL would the record be dropped.
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
what is difference between COM & DCOM?
what is diff between IN and EXIT commands
What are the session parameters?
Different qualification between a related rotate toward the sky and isolates look upward?
what is degenerated dimension?