What is the surrogate key?
No Answer is Posted For this Question
Be the First to Post Answer
How informatica recognizes mapping?
Briefly explain the aggregator transformation?
What is the Router transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
How to go to the older version for a mapping?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to delete the (flat file) data in the target table after loaded.
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
Can i create a lookup table without cache.
Can we call a stored procedure from a unix script which is run using command task
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...