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 |
Which are the different editions of informatica powercenter that are available?
how many types of dimensions are available in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
how can we load starting with 11th record of a table from source to target
Router T/R is active but some people are saying it is also passive which is exactly right?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
What are the main features of Oracle 8i with context to datawarehouse?
how do u move the code from development to production?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
What are two types of processes that informatica runs the session?
What are the Differences between connected and unconnected lookup?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...