How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?
Answers were Sorted based on User's Feedback
Answer / triveni
rank transformation
ex: empno,ename
1,ramu
1,ramu
2,rani
2 ,rani
empno(group by),ename(returnport) top1 or bottom1
target: 1 ramu
2 rani
Is This Answer Correct ? | 14 Yes | 0 No |
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
Is there any model difference between ODS and DWH
what is data driven?
what is the use of Data Mart?
what is mean by grouping of condition column in lookup transformation?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
What are mapplets? How is it different from a Reusable Transformation?
What are the methods for creating reusable transforamtions?
write a query for how to eliminate the duplicate rows without using distinct?
what is mapping parameter and mapping variables
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.