Interested to Buy Any Domain ? << Click Here >> for more details...
How can we eliminate duplicate rows from flatfile,explain?
- 3 Answers
- 11864 Views
- I also Faced
- E-Mail Answers
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 constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Describe the impact of several join conditions and join order in a joiner transformation?
how do the project develops? pls specify right from the start to end in step by steps.
Explain grouped cross tab?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
What is A cache?
Explain reference cursor?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
What are some examples of informatica etl programs?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
What all join we can perform in LOOKUP transformation?
Teradata 
