Interested to Buy Any Domain ? << Click Here >> for more details...
How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 16566 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / moorthy. g
S-SQ-Exp-Rtr-Tgt1/Tgt2
Exp:
flag: decode(true, col1=prev_col1,'Y','N')
pre_col1=col1;
Rtr:
Group1 --- flag='Y' --- Tgt1 -- Duplicate Values
Group2 --- flag='N' --- Tgt2 -- Unique Values
Best Regards,
Manthiramoorthy. G
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What do you understand by a term domain?
What are pre and post-session shell commands?
What does “tail –f” command do and what is its use as an Informatica admin.
How does a sorter cache works?
How to extract sap data using informatica?
Explain what are the different versions of informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Differences between version 7.x and 8.x.
What is the function of look up transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How might one distinguish in the case of mapping is right or not without associating session?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain the tuning lookup transformation - informatica
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
