State the differences between sql override and lookup override?
No Answer is Posted For this Question
Be the First to Post Answer
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
What is use of batch file in informatica? How many types of batch file in informatica?
What is informatica? Why do we need it?
what is mapping parameter and mapping variables
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
How can we remove the duplicates from flat file source?
have u done any performance tuning? how u ll do?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
Which means the first record should come as last record and last record should come as first record and load into the target file?
Using Connected or unconnected lookup for performance wise which one is preferable?.
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance