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?
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 |
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what is surrogate id ?
Which is costliest transformation? costly means occupying more memory?
Explain grouped cross tab?
how many types of dimensions are available in informatica?
What is workflow? What are the components of workflow manager?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
What is IQD file?
How can we delete duplicate rows from flat files?
what are 3 tech challenges/ common issues you face?