How do you remove duplicate records in informatica? And how many ways are there to do it?
No Answer is Posted For this Question
Be the First to Post Answer
tell me the rules and responsblites in our project(my project is development)
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
how i will stop my workflow after 10 errors
What is souce qualifier transformation it is active or passive
What is an aggregator transformation? it is active why cant it be passive explain?
what is the difference between Informatica7.1 & informatica 8.1
If u r using dynamic cache lookup port will be thier in thet which option u will select
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
What is the session task and command task?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100