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
- 7629 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 |
What are events in workflow manager?
What is olap (on-line analytical processing?
In session log thier should not be a single error how will u do
what is the dashbords?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
What is the capacity of power cube?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to display null values on a target & non-null values on a target?
What are Rapid changing dimensions?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
List the transformation in informatica.
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
Teradata 
