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 |
What is the procedure for creating independent data marts from informatica 7.1?
What is the difference between Active and Passive transformation?
Can we insert and update a target table without using update strategy transformation?How?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
If we are using an aggregator but forget to mention the group by port .what will be the output??
How can we use mapping variables in informatica? Where do we use them?
How would you copy the content of one repository to another repository?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
what transformations are used for Variable port?
what are testing in a mapping level please give brif eplanation