Using Expression transformation how to remove duplicate
records from a relational source?
Answers were Sorted based on User's Feedback
Answer / prathibha
Hi,
Source->SQ->Sorter->Expression->FilterTarget.
Lets take a small example for this scenario.
Use a sorter to sort the input data.
ID Name
1 A
1 A
2 B
3 C
3 C
In Expression Transformation declare the following ports:
ID
Name
O_Count= iiF(V_port=ID,O_Count=O_count+1,O_Count=0)
V_port(Variable Port) = ID;
In filter transformation give the condition O_Count =0;
Let me know if there are any suggestions.
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / babu
Hi,
SRC-->SQ(ENABLE DISTINCT )-->EXP-->TRG
OR
IN EXP T/R TAKE 4 VARIABLE PORTS AND OUTPUT PORT,
SRC HAVEING THE COLUMNS LIKE COL1,COL2,COL3
SRC-->SQ-->SRT(PLEASE TAKE ALL ARE KEY PORTS)-->EXP
(VAR IS IIF(VAR1=COL1 AND VAR2=COL2 AND
VAR3=COL3),1,0)
VAR1=COL1
VAR2=COL2
VAR3=COL3
OUT=VAR
-->UPD(IIF(OUT=1,DD_REJECT,DD_INSERT))-->TRG
IF ANY THING WRONG PLEASE LET ME KNOW.
8861145051
Is This Answer Correct ? | 6 Yes | 9 No |
Answer / bijay
The mapping should be like this
SRC->SQ->EXP->TARGET
In source qualifier transformation select 'ENABLE DISTINCT',
then it will send only distinct record to the expression transformtion. And From expression transformation simply connect to the target
Is This Answer Correct ? | 2 Yes | 5 No |
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
Performance tuning( what you did in performance tuning)
What are active transformations.
Why we need XMLs?
How do we call shell scripts from informatica?
What are the different types of code pages available in informatica & how to implement it in your project?
What is difference macros and prompts?
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Define pmcmd command?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How