i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.
3 7304Post New iFlex SQL Server Interview Questions
Explain the two uses of blocking an account? : fi- general ledger accounting
What is desk checking and control flow analysis
Write a select query that will be displayed the duplicated site name and how many times it is duplicated?
How to input string in C++
Differentiate Between High Speed coupling and high torque coupling with examples.
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What is winforms c#?
What is interface in oop?
What software is needed for java programming?
What is a driver in computer?
What is the unit of magnetic flux density?
what is semi&full custom difference b/w these two?
Safety Engineering Questions and Answers
How do I remove table formatting in word?
What is plumbing/piping?