Interested to Buy Any Domain ? << Click Here >> for more details...
i have 2 flat files one table contains duplicates another one
no duplicates.... so i need like this i don't want
duplicates...pl's give me ans...
- 4 Answers
- 8904 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / teja
place sorter transformation after source qualifier of duplicates flatfile and enable property distinct
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / guest
with the help of joiner transformation we can join these two
flat file sources and reject the duplicate rows using normal
join in joiner transformation
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / ankit kansal
Hi Gow,
As Question specified there are two source files so you can not user Distinct clause in Source Qualifier.
http://deepinopensource.blogspot.com/
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / gow
Hi Teja
We can use distinct option in source qualifier of the table having duplicate records itself right? Why do we need to use sorter after the source qualifier?.
Please correct me if i am wrong.
| Is This Answer Correct ? | 0 Yes | 3 No |
in performance wise union is past,union all is past
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
What is workflow manager?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the difference between Bulk Load and Normal Load
How do you load alternate records into different tables through mapping flow?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
How can we create index after completion of load process?
What are Dimensions and various types of Dimensions?
Difference between Data and Index Caches?
can we see default group,when we use router?if yes how?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
Teradata 
