Interested to Buy Any Domain ? << Click Here >> for more details...
my table contain duplicate Records i wanna load uniq records
to my table . i have to pass the uniq records through
filter t/r how?
- 3 Answers
- 7915 Views
- ACS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pavana
Yes, Sort the data first , then in expression increment the
count based on theprev value . in filter give condition if
count =0 . it pass only unique value.
sd >> SQ>> SRT TRN>> EXP>> FIL>> TGT.
| Is This Answer Correct ? | 1 Yes | 0 No |
Use a sorter transformation after source qualifier.check
unique records in the proprrties of sorter,This will [ass
only unique record from the sorter.
| Is This Answer Correct ? | 1 Yes | 2 No |
How union transformation is active ?
what is degenerated dimension table with scenario
Can anyone tell me the new features in Informatica 9 Version?
how to get the first row without using rank t/r?
What is operational data source (ODS)?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
What is a repository manager?
What aer the out put files that the informatica server creates during the session running?
What are the out put files that the informatica server creates during the session running?
What are the reusable transforamtions?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
Teradata 
