How to eliminate duplicates in FF and oracle both
- 3 Answers
- 5900 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / ravindra.15aug
In RDBMS we can write sql queary in Source qualifer by
using rowid, in sorter by using select distinct option, In
aggregator by using groupby, in Rank by using groupby.
In FF level also we can do except sql queary in source
qualifier.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the surrogate key?
What is decode in informatica?
How can repository reports be accessed without sql or other transformations?
in reporting we add some new objects,how we get the count of the newly added objects to the report
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.
What are the main features of Oracle 8i with context to datawarehouse?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Where is metadata stored?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER 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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Explain about Informatica server process that how it works relates to mapping variables?
can we override a native sql query within informatica? Where do we do it?
